Is there a way to populate a foreign key when a form is opened from the form that contains the primary key? I have an order form with a button that opens a production form. NewHouseId is the primary key in the Orders form and is autonumber.
I would like the NewHouseId, foreign key to be populated when the Production form is opened from the Orders form. I tried putting =Forms![NewHouseF]![NewHouseId] in the control source of the Production form and it does enter the NewHouseId in the foreign key BUT when I try to close the form or go to the next record I get a message that says “You cannot add or change a record because a related record is required in table ‘OrdersT’”.