Im on the last leg of a project and i've seem to hit a road block.
What i am trying to accomplish to a way to link multiple client records to share financial information. The database is a booking system for pilates and is laid out as follows:
Clients table - contains all clients
Financials table - tracks payments
When a payment is made, they are paying for x-amount of visits. Every time an appointment is made and the client shows up the the appointment, the appointment is applied to the payment and the remaining visits is subtracted by 1.
What i need to do is have the ability to link multiple client records together so that they can all share a financial record.
Lets say we have the Smith family: Mom, Dad and child.
The father's record is the main record and that is where all payments are made. I need to be able to apply the mother and child's visits to the father's payments.
Any help would be greatly appreciated.