akomaz Posted March 3, 2010 Share Posted March 3, 2010 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? Quote Link to comment Share on other sites More sharing options...
mapleleaf Posted March 4, 2010 Share Posted March 4, 2010 two tables company_id company_name contact_id company_id contact_name Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.