Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Schapel, Steve
  New Posts New Posts RSS Feed - An Overview Of Relating Subforms in Access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

An Overview Of Relating Subforms in Access

 Post Reply Post Reply
Author
Message
Steve Schapel View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 04 Jul 2009
Status: Offline
Points: 10
Post Options Post Options   Thanks (0) Thanks(0)   Quote Steve Schapel Quote  Post ReplyReply Direct Link To This Post Topic: An Overview Of Relating Subforms in Access
    Posted: 04 Jul 2009 at 12:21pm

This is a common requirement in a database application.  Here are a few random examples:

  • You manage financial transactions in your database.  You have a form based on a Bank Deposit, where you use a continuous view or datasheet subform to list all payments received.  And then, for each payment, you need to split the amount in order to allocate to potentially more than one account code.
  • You are running a tournament for a team sport.  For each Grade/League/Division of the tournament, you want to see a list of the teams entered.  And then, within the same user interface, you want the ability to see information about the players registered for each team.

So, this requirement typically arises in databases where you are working with data in a one-to-many-to-many configuration.

This article is an introductory overview of the possibilities.  The example used is not intended to be a complete solution.  It has been simplified in order to illustrate the concepts.  Screen shots are in Access 2003, but the same approaches can be applied in other versions of Access, including Access 2007...

Read more here: http://accesstips.datamanagementsolutions.biz/subsub.htm

Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.