Unanswered: Best way to associate one to many setup...
Hi. We're trying to setup a new case management system and I'm having a problem trying to store some of the information. I think I know how to go about it; however, I'm not sure if it's right.
We have two tables: Cases and Clients. The cases table stores relevant case information like case number, case type, etc. The Clients table stores information like name, address, phone number, email, etc.
What is the best way to associate these two tables together? I'm assuming I need a third table. Right? Thanks!
We will only have one case. However, each case can have multiple clients. We have a CaseID and a ClientID in each table serving as the primary key. What would I need in the third table? I was thinking:
Would I need a primary key for this table? Or are the two columns sufficient?