Display Parent Data on a Child Form

[rlowden]

I am sure this is simple, but I cannot figure it out. I have a table of Organizations related to a table of Staff members in a one-many relationship. They are linked by a unique identifier PartnerID.

On the form showing staff members, I simply want to display data from the linked Organization table (such as the Organization name a given staff member belongs to).

Do I use a text box? And how do I program it to show the information?

Many thanks for your input.

Bob

 

[KenHigg]

Several ways. One way is to add the table in the form record source query and link it to the main table. Think this would work?

 

[rlowden]

Thanks Ken for your advice. I changed the form so that it is based on a query (it had been based on the underlying table) and went from there. It was straightforward.

I was away so I did not get to respond until now. Many thanks. Bob

 

[KenHigg]

Glad you have it working -