I run a cat sanctuary and I’m wanting to keep track of vet charges for each individual cat. So I would make a Table for Harry and then I would create a record with all the charges for a certain date. But can I actually do that? The way I’m looking at it now, I would have to create a separate record for each individual charge. Is there a way I can create one record for each invoice?
Page 1 / 1
Hi there @Bliss_Marsh!
Sounds like you’re thinking in the right direction 
You will definitely need to create a separate record for each individual charge if you want it to be listed separately on an invoice.
Check out my example Invoices and Line Items Base:
This base demonstrates how to build an invoice with separate line items of varying quantities/costs. For your use case, you could equate the eItems] table to the eServices] you provide. I’d also assume you’d want to add a table for ePets], and it would probably be linked to both the hLine Items] and ]Customers] table (this is assuming that a hCustomer] can have multiple tPets], and an nInvoice] may have multiple tPets] per ]Customer]).
Hope this helps to get you going!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.