I'm looking for the best way to store data and allow for two sets of unique IDs.
For instance if I had a table that contained a list of company names and individual contacts for each of those companies, both the company and the contact would have unique IDs.
This would allow for selecting a contact by its unique ID, or selecting a group of contacts by the company ID.
What is the best way to accomplish this?
