Print Page | Close Window

An Overview Of Relating Subforms in Access

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Schapel, Steve
Forum Description: Steve Schapel's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=474
Printed Date: 28 Mar 2024 at 12:57pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: An Overview Of Relating Subforms in Access
Posted By: Steve Schapel
Subject: An Overview Of Relating Subforms in Access
Date 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 - http://accesstips.datamanagementsolutions.biz/subsub.htm



-------------
Steve Schapel
http://accesstips.datamanagementsolutions.biz/ - http://accesstips.datamanagementsolutions.biz/



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net