AnsweredAssumed Answered

Database Relationships

Question asked by beverlyelle on Jul 5, 2018
Latest reply on Jul 12, 2018 by BMyers


I am trying to build a database for our firm, but I'm having trouble with building relationships. Here's an idea of what I need:

For each client, he or she can have multiple cases. Each case has their own corresponding invoice and billing.

For each case, there can be different types of cases: criminal, immigration, civil, or post-conviction.

Depending on the type of case it is, I was going to create different fields.

 

I have my database for my clients set up but when I went to connect it to their specific cases, it would show every client's cases instead of just the individual client's cases.

Outcomes