Hello,
A simple database question. Suppose I have two tables: A commodity types table, and a manufacturer's data table with prices from manufactures of particular commodities all of which must be on the commodity types table. A commodity type is "uniquely defined" by three different fields.
I need to relate the two tables together. Should I include these three fields on the manufacture's data table as well and then join by these three fields, or should I create a new "primary key" field (like an AutoNumber) on the commodity types table which would uniquely identify a commodity and then include this field on the manufactures data table and join by this new field. I guess I'm wondering what the best DB practice is.
There can be many different manufacture entries corresponding to a single commodity type. Each manufacturer entry has to correspond to one of the commodity types.
Thanks in advance for the help,
CM
A simple database question. Suppose I have two tables: A commodity types table, and a manufacturer's data table with prices from manufactures of particular commodities all of which must be on the commodity types table. A commodity type is "uniquely defined" by three different fields.
I need to relate the two tables together. Should I include these three fields on the manufacture's data table as well and then join by these three fields, or should I create a new "primary key" field (like an AutoNumber) on the commodity types table which would uniquely identify a commodity and then include this field on the manufactures data table and join by this new field. I guess I'm wondering what the best DB practice is.
There can be many different manufacture entries corresponding to a single commodity type. Each manufacturer entry has to correspond to one of the commodity types.
Thanks in advance for the help,
CM