database development in london - How does sub-documents work?

The UK's most regular instructor-led training courses.
Training information: database development in london · Access course microsoft training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

How does sub-documents work?

Jonathan has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

by - delegate Jonathan [4 posts] (2007 Aug 6 Mon, 10:41) Reply

How does sub-documents work?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: How does sub-documents work?

by - trainer Richard platinum contributer [813 posts] (2007 Aug 7 Tue, 10:51) Reply

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

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Discover the Secrets within Your Business through Microsoft Access Training
· Access VBA Training Adds Power to your Databases
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· The Benefits of Certified Microsoft Training in Access

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips