One order, multiple invoices

[jerem]

Hi,

Attached is a modified version of the Goods database from Ms.

For the moment, the tool is invoicing per order, but I would like to build the structure so that per item invoicing becomes possible. For example one order would have 3 invoices. The user should be able to select items to invoice and change quantities (from an invoicing form that would link to the order). The way I was contemplating that is with a new query or a buffer table but I am not yet sure on the way to build the whole thing.

June7 was suggesting:

Possibly control this in report set up as invoice document. Design report to force new page after each item. Good topic for a new thread when you have specific issues with report design.
Discretionary selection of items to invoice requires applying filter criteria. Maybe a Yes/No field in table. Invoice items checked yes?

Any advice? Other ideas?

View attachment Goods.zip

 

[jerem]

I am stuck here! When I create a new order, I have a Form linked to Order tables and a Subform linked to OrderDetails table that get created and data is sent to both tables accordingly. For invoicing, I would like exactly the same to happen: An Invoice table and an InvoiceDetail table with corresponding Form and Subform. The only difference is that I would like the form to be loaded with the corresponding data from Oder and Order details form but then update data into InvoiceDetail Form. And that is what I am not able to do. Use existing data in orders and then switch to invoice.
I'd even know how to do it in Excel VBA but in Access I am stuck. Thanks a lot for your help!