Microsoft Access无法添加记录集不在表中的表的联接键 [英] Microsoft Access cannot add records join key of table not in recordset

问题描述

我知道这是一个转贴，我已经对所有可能的问题进行了研究，找不到任何可以帮助或帮助我解决当前问题的方法.无论我重新创建查询或表单有多少次，我似乎都无法使其正常工作.如果运行查询，我将显示正确的信息，但是在通过我创建的自定义表单添加信息时，会出现此错误-> "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-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".

我当前的查询，以防万一.我只从供应商表中访问vendorNoID.我需要其余表格中的所有信息.

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.

我能够以这种形式输入tbl_address和tbl_addressType的信息，但是我得到了vendor/purchaseOrder的错误.是什么原因造成的?！?！

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?!?!

任何建议将不胜感激

推荐答案

供应商组合框的选定值必须绑定到[tbl_purchase_order].[vendorID].到表中，所选值是外键.

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.

它必须与您对address_typeID所做的相同.

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

这篇关于Microsoft Access无法添加记录集不在表中的表的联接键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！