Saving invoice

[axw]

Hello, I'm confused / stuck. I want to make an invoice with products and services and totals, the thing that has me wondering is how do I save an invoice with multiple lines in the item section of the invoice. I want to be able to choose a customer and then see the list of invoices connected to that customer, and when I click the invoice to open it as it was. What would be the best way to do this?
The invoice contains:

• Customer info, adress, name...etc
• List - multiple lines of products sold / services completed
• Totals, date & time...etc

Relationship goes like this: Customer -> Invoice <- Inventory / Services

Thanks in advance.

 

[bob fitz]

You will need to get your table structure correct. You will need at least four tables.

1 Customers
2 Orders
3 OrderDetails
4 Product

See the attached file for illustration of relationships.

 

[DavidAtWork]

Once you have your table structure correct, you can create a forms to generate an order. Select customer, select product line, enter quantity and other details, then repeat for as many products/services in that order.
For the invoice itself, just design a report that pulls in all the order details, if an invoice can contain many orders, then you'll need an Invoice table plus an InvoiceOrders table where you can select the order(s) to be included in the invoice.
With the invoice viewable from a report, this can be printed or saved as a snapshot/PDF. The invoice report can be designed so that on demand, all invoices for a selected customer, can be viewed

 

[axw]

Thanks a lot to both.