Invoice

[gensor]

I would like to create a form for invoicing and I'm stuck!



I want :

- A header with Order ID, Date, Client's information.
- A subform for products in the order (Product Number (Drop-down list), Product Name (Drop-down list), Quantity, Price, Total price)
- A footer with Price order (total of Total Price in the subform)

I want this form to be able to show current orders either with previous-next scrolling and with a search button.

The problem I have is that new orders will have to be saved in multiple table and I'm not sure how to do this

The product are on a different table. There's a table with the order info (ID, Client ID (which link to client info), Total Price, ...) and a table with product in the order (Product ID (which like to product info), OrderID, Quantity, Price, Total...)

Is there anyone who have an example of this ?

[orange]

You haven't told us about the purpose of the database --only about 1 form.

I strongly suggest you work with this tutorial from Rogers Access Library to ensure your tables and relationships are designed to meet your business needs.
If there is any issue with your tables and relationships, you will be constantly creating work arounds to get data into and out of your database.

There are several free data models here that may give you design ideas.
Good luck.