I have a Customers table that holds a customer account number, Customer name, Street, City, State, Zip.
I want to make a lookup table for City and a lookup table for State.
Should I use the State Abbreviation for the Primary Key or an Autonumber?
I want to make a lookup table for City and a lookup table for State.
Should I use the State Abbreviation for the Primary Key or an Autonumber?