Hi all,
I hope I put this question in the correct Forum section.
Here are the rules in my database:
- My database has people for which you can be a client or volunteer.
- Each client can have multiple insurances for which there are multiple authorizations.
- An authorization allows an invoice to be made.
- An invoice allows a client to be visited by a volunteer.
I've attached a relationship for my DB for viewing. Could this relationship work? Should I consider changing my tables? This is my fifth try (I've lost count) at making this DB. I already made the mistake of designing time-consuming forms that I had to trash.
Any help would be great!