Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
database development in london - how does subdocuments work

Forum home » Delegate support and help forum » Microsoft Access Training and help » database development in london - How does sub-documents work?

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

ResolvedVersion Standard

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

How does sub-documents work?

How does sub-documents work?

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

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.