I have a large database of World Postage Stamps.(600,000 records)
The different Varieties are in a table (called ‘varieties’)
This ‘Varieties’ table contains 3 fields (Plus other fields)
CountryID is the first numeric field that contains many different countries
TypeID is the second numeric field representing General Issue, Airmail, Postage Due, etc.
CatalougeID is the third field that needs to be unique under Countryid and typeID
Currently the three fields are all set up as Primary keys within the Varieties table. This avoids duplicates.
Is this the best way forward, as I want to allow other people to edit this table?