Creating a parent/child link within form

[Reese]

[SOLVED] Creating a parent/child link within form

I have a relationship between two tables; the parent table is "Client Information" with a primary key of "Client_ID", the child table is "Event Information" and the foreign key is "Client_ID".

I know that within the Event Information table I can select which Client_ID to use as the link. I want to have that done within a form, however. I have a form for Client Information with a subform for Event Information. If I go into the table and manually set the Client_ID then everything displays fine.

How can I set the Client_ID in the subform to automatically match the Client_ID in the main form? I've searched for various answers in these forums and in others but none of the solutions seem to work. I can only assume that these solutions require the parent/child relationship to already have been established.

Thanks!

 

[missinglinq]

...I can only assume that these solutions require the parent/child relationship to already have been established...

Not at all. In Form Design View, for the Main Form, select the Subform Control then go to Properties - Data and set the Link Master Fields and Link Child Fields Properties to Client_ID.

Linq ;0)>

 

[Reese]

Thanks! I'll try it out when I next have the chance. Though technically I'm on vacation so it may be a little bit. I'll let you know how it turns out.

 

[Reese]

It worked perfectly, thanks!

 

[missinglinq]

Glad we could help! Hope vacation was enjoyable!

Linq ;0)>