Invoicing form setup

[tl mike]

I am still learning how to setup db's but am able to get myself around with some VB and have a decent knowledge of Access.

With that said:

I am having a hard time figuring out how to setup my invoicing form to which it will pull the products ordered from the order to show how what and how many pieces were ordered. Then giving me the ability to add how many we can invoice and show how many is back ordered. With the ability to do another invoice to ship the remainding qty. on a different invoice.

A copy of my db is attached

Any help will be greatly appreciated since I have been stuck on this for the past couple weeks.

 

[heedaf]

Can you give more detail in what you are trying to do?

 

[tl mike]

In the invoice frm I would like to have a subfrm that is viewed in datasheet. In which I see what the customer ordered (Part Number), Description of product, Qty ordered, Qty already invoiced, then a place that is unlocked to which I can enter the qty to be invoiced, and one more cell to show how many back ordered.

My problem is the link child/ master fields to the subform in which I can see what the customer ordered and that in the tblInboicedetails the PK for the part number will show and the qty shipped.

 

[ajetrumpet]

In the invoice frm I would like to have a subfrm that is viewed in datasheet. In which I see what the customer ordered (Part Number), Description of product, Qty ordered, Qty already invoiced, then a place that is unlocked to which I can enter the qty to be invoiced, and one more cell to show how many back ordered.

Well, that's kinda funny Mike. There's an example of that idea here:

http://www.access-programmers.co.uk/forums/showthread.php?t=137158

 

[tl mike]

Ive already look at that and the way it is set up with a temp tbl ect wouldnt work for me.

 

[ajetrumpet]

Ive already look at that and the way it is set up with a temp tbl ect wouldnt work for me.

Why not? Where's the incompatibility?

 

[tl mike]

I just want to work on just one order at a time and dont want a temp file because I need to show each time a product is shipped I looked threw the VB but nothing there is really what I want to do with the db. But I will look at it a little closer and see if there is something I could use that might help me.

Here is a more normalized and a quick word doc that will kind of show what I am looking to do