Forum home » Delegate support and help forum » Microsoft Access Training and help » database development in london - How does sub-documents work?
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
database development in london - How does sub-documents work?
Resolved · Low Priority · Version Standard
Reply Mon 6 Aug 2007, 10:41Delegate Jonathan said...
Jonathan has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
How does sub-documents work?
How does sub-documents work?
For upcoming training course dates see: Pricing & availability
RE: How does sub-documents work?
A Subdocument is an embedded data set. So you have your primary data, for example a list of clients. Your subdata set could be a table or query containing anything relating to these cleints, perhaps purchases. So when you link the subdata to the primary data you can view the related recoards more easily.
An example might be a subform. Here your main form contains the client data fields and the subform contains the sales. As you scroll through the cleints records, the subdata will change according to the current client record.
Does that cleirfy it for you?
Regards
Richard
|