我认为不能仅使用表来完成此操作-您必须创建一个表单,该表单将限制基于类别的描述列表框中的选择。
此外,您的数据结构还存在许多问题:
Furniture
s can have the same CATEGORY
. This means that CATEGORY
cannot be the primary key -- a uniquely identifying piece of data -- for Furniture
. I would suggest adding a Long number column called FurnitureID
. If you make this an Autonumber column, every new record will get a new number by default; otherwise you'll have to insert the number by hand.Stock
of the same type (or Long if the FurnitureID
is an Autonumber). These two columns should be related in the Relationships window. The relationship means that every1 Stock
record must have a related Furniture
record with the same data in both records.CATEGORY
and DESCRIPTION
fields between the Stock
and Furniture
tables. This means no duplicate data, and no potential conflicts.1. Depending on how the column is defined, it might be possible to have no data in the foreign key column in the Stock
record; but this is relatively uncommon
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句