Order/ Invoice Design Problem

[tl mike]

I am working on a Invoicing DB that I would like to be able to place an order and then Invoice that order and ship what we have in stocka an back order remaining qty then when we recieve more invoice the rest to that order. I have set up my table as such

tblCustomer
Cusotmer information

tblProducts
Product informaition

tblOrders
Shipping informaition and PK of Order ID

tblOrderDetails
PartNumbers ordered and Qty ordered

tblInvoice
PK of Invoice ID and linked to Orders by OrderID
Other invoicing info

tblInvoiceDetails
Qty shipped/ Invoiced link to Invoice by InvoiceID

In the invoicing part I plan on setting up a form with a List box with a Query showing Part ordered and Sum of Qty in which you select the part on the list box the informaition is pulled up on the form you enter the qty shipped and press a button to save that in which it updates the query and the list box with the new shipped qty.

My biggest thing does this design sound like it will work and how to set up the Line Items form in which I can select the part update the info and then have a button to accept the changes.

Any help would be appreciated.

 

[tl mike]

Here is what I am working on so you can get a feel for what I am trying to do there are a lot of small things I have to fix but what I really want to do is get the list box linked with the accept or clear buttons.