I know you (the experts) usually prefer using an autonumber to a custom ID. However ....
This is for a jewelry company. They identify each inventory item by a one letter indicating type (e.g., W=watch, R=ring), and a number. The numbers increment for each type of item (e.g., W1, W2, W3, ...; R1, R2, R3, ...). Thus, the primary keys are a combination of two fields:
ItemType - 1 char text
InvNo - long integer. I will be* adding these using dMax + 1.
*I say "will be" because the database I took over had the different types of items in separate tables (with an autonumber). I initially brought them together via union queries (didn't have the time budgeted to do a full redesign until now).
So, do I have a good reason to drop the autonumber?
Adam
Denver, CO
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar