Microsoft Access Cannot Add Records Join Key Of Table Not In Recordset

I know this is a repost, I have done my research on everything possible and I couldn't find anything to assist nor help me with my current problem. No matter how many times I re-cr

Solution 1:

The selected value of the vendor combobox got to be bound to [tbl_purchase_order].[vendorID]. To the table, where the selected value is the foreign key.

It's got to be the same as you already did with the address_typeID.

Solution 2:

The selected value of the vendor combobox got to be bound to [tbl_purchase_order].[vendorID]. To the table, where the selected value is the foreign key. (@VMai)

In my opinion, open the Query Builder of Form (as picture below), then add column [tbl_purchase_order].[vendorID]

/

Cause I don't have enought reputation for write comment, so I write down here. Hope it help ! ^^