Please Help with Subdatasheets!

[nitinrao]

Hi everyone,

I'm trying to make the subdatasheet for my tables (I've attached a snapshot of the relationships) which shows the following:

- The "Key Users" table with a subdatasheet that shows everything from table "Key Assignments" and fields "Building" and "Room" from table "Key"

- The "Key" table that shows everything from table "Key Assignments" and fields "Last Name" and "First Name" from table "Key Users"


How can I set this up? I've been breaking my back trying to figure this out...
if there are other ways to show this when clicking on the expand button in each table, please offer them (other than using queries).

Please let me know if you'd like to see the database....

 

[Galaxiom]

Forget subdatasheets. They only work with direct views of tables and queries. These techniques are not how data should be presented to a user.
Use subforms.

 

[nitinrao]

Forget subdatasheets. They only work with direct views of tables and queries. These techniques are not how data should be presented to a user.
Use subforms.

is there any way to pull out the relevant fields that I posted about? Presenting simply an "ID" is irrelevant to the user. Please let me know.

 

[Galaxiom]

Forms and subforms can both use Record Source queries to select the fields you require. Click the right hand end of the Record Source property to build the query.

Bound controls on the foms display the values from the fields in the Record Source. Type the name of the field you want in the Control Source property of the control (or just directly into the textbox in Design View of the form).

Subforms are connected to the current record of the main form using the Link Master Fields and Link Child Fields properties of the subformcontrol that holds the subform object.

 

[nitinrao]

Forms and subforms can both use Record Source queries to select the fields you require. Click the right hand end of the Record Source property to build the query.

Bound controls on the foms display the values from the fields in the Record Source. Type the name of the field you want in the Control Source property of the control (or just directly into the textbox in Design View of the form).

Subforms are connected to the current record of the main form using the Link Master Fields and Link Child Fields properties of the subformcontrol that holds the subform object.

could you please elaborate on how to set this up? I'm a beginner to access.

 

[nitinrao]

Forms and subforms can both use Record Source queries to select the fields you require. Click the right hand end of the Record Source property to build the query.

Bound controls on the foms display the values from the fields in the Record Source. Type the name of the field you want in the Control Source property of the control (or just directly into the textbox in Design View of the form).

Subforms are connected to the current record of the main form using the Link Master Fields and Link Child Fields properties of the subformcontrol that holds the subform object.

I actually figured it out...thanks a lot!!!

I was wondering how i can extend the border of the form so I can show the subform without scrolling?

 

[Galaxiom]

I was wondering how i can extend the border of the form so I can show the subform without scrolling?

Drag the edges of the background with the grid lines in the form designer.

 

[nitinrao]

Drag the edges of the background with the grid lines in the form designer.

DUDE! you solved all my problems. You also clued me into how to build a subdatasheet with my own fields (i didn't know we could use queries to do this!) THANKS A TON!!