AnsweredAssumed Answered

Relating a Pet Library to Customers and Invoice - starter solution "Invoices"

Question asked by Maruy on Jan 19, 2011
Latest reply on Jan 20, 2011 by philmodjunk

Title

Relating a Pet Library to Customers and Invoice - starter solution "Invoices"

Post

Hello.

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.

Maruy

Outcomes