How can I auto populate related foreign keys with the primarykey autonumber?

[sflinda]

For instance, I have a table (Vendor) with primary key VendorID which is related to another table called Products with VendorID as a foreign key. I have a form that allows the user to search on a particular vendor and bring up another form with products, contacts etc relating to that one vendor. However, if I try to add a new record for a new product on this form I get an error message, as the VendorID field in the table Products is not automatically populated by the auto number assigned in the primary key field VendorID in main table (Vendor).

I've tried combo boxes, linking fields, select queries using SELECT DISTINCTROW but no luck - any ideas?

I'm hoping that all I need to do is to automatically populate the foreign keys with the auto number assigned to their related primary key field?

thanks.

 

[josephwalter]

Put a hidden textbox on the Product form.
Set the Control Source to VendorID (the foreign key field of the Product table).
Then set the Default Value property to the VendorID textbox on the Vendor Form
(i.e. =Forms!frmVendor!txtVendorID... your object names may be different, but I hope that clarifies the idea).

 

[bloody_football]

Pat

Sorry for the newbie questions but I gota ask - how does this line

Me.VendorID = Forms!YourOtherForm!VendorID

look if you need the ID from a table which is called Quotes? I tried

Me.ID = Tables!Quotes!ID

and a few other variations but without success.