Linking forms based on two fields

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a form based on one table that I want to include a subform based on
another table. I know about the parent/child link property but I want to link
the records on the sub form with two controls on the main form so that the
main form data is automatically entered into the corressponding two fields in
the second table.
How do I do this?
Thanks
Tony
 
Thanks Pieter, sounds easy enough.
Tony

PieterLinden via AccessMonster.com said:
In the LinkChild and LinkMaster fields, enter the field names separated by
semi-colons, like this:

LinkChild Fields: hPatientID;hProtocol
LinkMaster Fields: ePatientID;eProtocolID
 
Back
Top