Form/Subform - Two reference fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that has two relevant fields on it. "FILE" and "PROJECT"

Linked to the "FILE" field is a Subform with a note. Because of the link,
the subform table automatically records the "FILE" in which it was entered.
I also need the "PROJECT" to be recorded in another field of the subform
table. I do not know if I can link more than one field from my form to my
subform or if I need a command to find and insert the data "PROJECT" when I
create a record in the subform.

Please help.
 
yes, you can have multipl controlnames in LinkMasterFields
and LinkChildFields -- delimit them with semi-colon ;

It would be better, however, to use an Autonumber field in
your main table and a corresponding Long Integer in your
child table for the behind-the-scenes linking

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com
 
Back
Top