Picking orders for invoices

[haze]

Hi everyone,

I'm sort of new to Access, but over the past few months I've been able to develop an inventory database for my work which turned out quite nicely and does everything I need it to, except for one thing.

I want to also create invoices for my customers, and after looking at examples I understand that most people link the "order" with the invoice, so that there is one invoice per order. However, I need the ability to combine many orders into one invoice. That's where I'm stuck.

I don't know how to arrange my relationships and forms so that I can "pick" the orders I want on my invoice, and not at the time of the Order, but at some point after. Basically my orders will be established, but their allocation to invoices won't, until I come along and put them into their rightful bill.

Does anyone have any thoughts on this? I'm pretty stumped.

Thanks a lot for your help.

 

[FoFa]

Create an Iinvoice to Order relationship table, and handle it there.

 

[haze]

Wow, thanks for the quick reply FoFa.

I played around briefly with what you suggested, and although I see that I can pick my orders, I'm having trouble displaying the order details of my orders all together. If i have my invoice as the form, and the orders combined with orderdetails as the subform, then when I pick the order only the first orderdetail is shown. If I have my orders as the subform, and then another subform showing its details, I can't add the prices of the details together.

Is it possible to display the information I want, (viewing orders but also detail price totals) in this situation?

I think my skill level and understanding of access is really holding me back here.

Thanks again!