Print Page | Close Window

SubForm3Levels.mdb (advanced)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=263
Printed Date: 28 Mar 2024 at 9:34am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: SubForm3Levels.mdb (advanced)
Posted By: Roger Carlson
Subject: SubForm3Levels.mdb (advanced)
Date Posted: 21 Jul 2008 at 10:58pm
 
Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 
SubForm3Levels.mdb
 
Access does not allow more than two levels of subforms. At times, however, your data model indicates the need for more levels. This is one way to implement a third level through the use of a list box. The basic model is that each Visit (tblVisits) can have many Procedures (tblVisitProcedures) which can in turn have many Complications (tblVisitComplications) which can have many Interventions (tblVisitInterventions). See the Relationships Window. *Note, the other tables are simply look-up tables for the combo boxes.
 
Download
Access 97 (71 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/SubForm3Levels97.zip - uploads/5/SubForm3Levels97.zip
Access 2000 (80 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/SubForm3Levels2k.zip - uploads/5/SubForm3Levels2k.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



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