Hi!
A coworker and I are having a debate about the most correct way to do something. I'll attempt to describe this as objectively as possible.
We have a database with several lookup tables. This is for building motors, so the tables are for things like bearings, the enclosure for the motor, customer names, etc. So, let's use the bearings as an example.
In one table we have a field describing the type of bearing used (whether it should be an ID# or not is part of the debate). In another table we have a list of the different types of bearings to be used as a lookup on a form.
Question 1: In the lookup table, should the type of bearing be the primary key, or should there be an autonumber? One would be a text, the other obviously a number.
Question 2: In the database, should there be a formal (one-to-many) relationship between the bearing lookup table and the motor information table, or should the lookup table just be bound to a combo or drop box in a form with no relationship defined?
Hopefully I asked those in an unbiased way.
Feel free to ask if there are any clarifying questions needed.
Thank you!
Timothy
A coworker and I are having a debate about the most correct way to do something. I'll attempt to describe this as objectively as possible.
We have a database with several lookup tables. This is for building motors, so the tables are for things like bearings, the enclosure for the motor, customer names, etc. So, let's use the bearings as an example.
In one table we have a field describing the type of bearing used (whether it should be an ID# or not is part of the debate). In another table we have a list of the different types of bearings to be used as a lookup on a form.
Question 1: In the lookup table, should the type of bearing be the primary key, or should there be an autonumber? One would be a text, the other obviously a number.
Question 2: In the database, should there be a formal (one-to-many) relationship between the bearing lookup table and the motor information table, or should the lookup table just be bound to a combo or drop box in a form with no relationship defined?
Hopefully I asked those in an unbiased way.
Feel free to ask if there are any clarifying questions needed.
Thank you!
Timothy