Pull Data From Many Tables

[Nanette]

I have several tables that are all connected by Entity Relationships in a
reasonable fashion.

I want to pull data from 4 tables (already in sub-datasheet design) and put
them as sub-datasheets on one Sub-Form, but Access is not recognizing the
ER's that are not directly tied to the base form.

i.e. Cabinet Table (base form) has direct ER to Part Table and Part Table
works fine. Part Table has direct ER to Part Details table. When I put the
Part Details on the Cabinet form it only give me options to connect (primary
key to child key) to the Cabinet Table and Part Table.

What am I missing?

 

[Damian S]

Hi Nanette,

You can fully specify the link if you need to, use something similar to this
in the properties for your child form:

Link Child Field: NAME_OF_CHILD_FIELD
Link Master Field:
forms!MAIN_FORM_NAME.NAME_OF_SUBFORM_CONTROL.form.NAME_OF_LINK_FIELD

You can't use the subform field linker by clicking the three dots... but you
can type it manually!!

Hope this helps.

Damian.

 

[Nanette]

Thanks Damian.

I'll give it a shot.

Hi Nanette,

You can fully specify the link if you need to, use something similar to this
in the properties for your child form:

Link Child Field: NAME_OF_CHILD_FIELD
Link Master Field:
forms!MAIN_FORM_NAME.NAME_OF_SUBFORM_CONTROL.form.NAME_OF_LINK_FIELD

You can't use the subform field linker by clicking the three dots... but you
can type it manually!!

Hope this helps.

Damian.

 

[Nanette]

Hi Damian,

I know I've seen the Link Child Field and Lind Master Field properties
before, but I can't them now. Where do I click on the form to bring up these
properties?

 

[Damian S]

Hi again Nanette,

They are on the "Data" tab of the properties of the SubForm control on the
main form.

Damian.

 

[Nanette]

Thanks again. It's time to go home now so I'll try again tomorrow.