Invoicing

[carelfly]

I would like to use my database to generate invoices...
i have a customer table with customer info, a invoice table to collect data for each invoice. i want to insert a subform to collect the invoice detail (individual invoice lines). i am having trouble getting the queries in the right place to calculate subtotals and totals, should i use the query as a complete subform and use the query to append a table (invoicedetail) or use a table as the subform (how do i do the subtotal and total fields)

i also have three different criteria for different type of invoices - would it be possible to use the criteria to change the subform to enter different data for each category

 

[HiTechCoach]

First I would recommend that you take a look at the Northwind sample database. Check out the invoice.