Relating a Pet Library to Customers and Invoice - starter solution "Invoices"
I was hoping someone can help me create/use the correct relationship among customers, pets, invoices. I am trying to create a database for a 2-doctor veterinary practice.
I am using the Starter Solution "Invoices" as it conveniently has the Customers, Products and Invoices.
I want to add another Table named "Pets" and relate it appropriately to Customers. The pet will be related to a particular customer (aka Clients). A customer can have several pets but a pet usually has just one owner. I am planning to just add another field called Other Owner in the Customers table to accommodate a spouse/family member who shares ownership with the same pet.
The invoice will contain services/products that the pet incurred while in the vet clinic.
In the Invoice lay-out, I wish to have the Customer Info, the Pet Info and all the line items (services/products) for that particular transaction.
Thank you very much for all your help.