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.