问题描述
您好
我有一个表PRODUCT NAMES，字段为PRODUCTNAME和COMMODITY，另一个表名为COMMODITY NAMES，只有字段商品（包含7种不同商品的清单），以及名为ENGINEERING的表单，带有两个单独的组合框（PRODUCTNAME和COMMODITY），用户必须从已填写的PRODUCT NAMES表中选择一个产品，该表显示为options。
我需要表单中的COMMODITY组合框自动在PRODUCT NAMES表中显示其相关PRODUCTNAME的值。如果该特定产品没有已经指定的产品，则用户可以从组合框列表中选择商品（行源是COMMODITY NAMES表上的COMMODITIES字段）。
我该怎么做？或者
是否有可能或者更好地删除商品名表，以便最初每个产品都必须填写相应的商品？
谢谢，
Gilberto
Hello
I have a table PRODUCT NAMES with fields PRODUCTNAME and COMMODITY, another table called COMMODITY NAMES with the only field COMMODITIES (containing a list of 7 different commodities), and a form called ENGINEERING with TWO separate combo boxes (PRODUCTNAME and COMMODITY) where the user has to select a product from the already filled in PRODUCT NAMES table which are displayed as "options".
I need the COMMODITY combo box in the form to automatically display the value of its related PRODUCTNAME in the PRODUCT NAMES table. And if that specific product doesnt have an already specified one, that the user could select the commodity from the combo box list (which "row source" is the COMMODITIES field on the COMMODITY NAMES table).
How can i do this? or
Is it possible or is it better to delete the COMMODITY NAMES table out of the question so that initially EVERY product has to have their corresponding commodity filled in?
Thanks,
Gilberto
推荐答案
Scott，谢谢你的回复。
正如你想的那样1商品可以分配给多个产品，但产品只能有一种商品。我已经有两个相关的表（商品和工程）和我的COMMODITY组合框（在工程表格中）我已经有：
Scott, thank you for your reply.
As you supposed 1 commodity can be asigned to more than one product but a product can have ONLY one commodity. I already have the two tables related (COMMODITIES and ENGINEERING) and on my COMMODITY combo box (in the ENGINEERING FORM) i already have:
这篇关于汽车。以表格形式显示表记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！