Microsoft Access cannot add records join key of ta

Question

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-create my Query or Form, I just can't seem to get it to work correctly. if I run my Query, I will get the correct information displayed, but when it comes to adding information through a custom form I made, I get this error -> "cannot add records join key of table not in recordset".

My current Query, incase you wanted to see. I only access vendorNoID from the vendor table. I require all the information from the rest of the tables.

I am able to enter information in this form for tbl_address and tbl_addressType, but I get the error for vendor / purchaseOrder. Any reason whats causing this?!?!

Any advice will be greatly appreciated

Answer 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.

Answer 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 ! ^^