Help with an Append Query

[tl mike]

I am trying to setup a Append query in which you use an open form button and it appends data to the form that I am opening

The data on the main form is order info
OrderPK
ProductFK
UnitPrice
Quantity

On the Invoice form I want the data
ProductFK
UnitPrice

to append to the Invoice details tbl so I can see what the customer ordered and gives me the ability to invoice what we have on hand and then invoice later when we get more in. My other problem is linking the data to the order that I am working on instead of appending everything from the orders table to the invoice table

 

[MStef]

Hello mike!

I think your tables not normalized well. You have to learn something about
DATABASE NORMALIZATION. I don't know your task, but I can suggest two tables "tblOrder" and "tblProduct", (you can add more tables, dependeng on your task). Make a MAIN FORM on "tblOrder", make a SUBFORM on "tblProduct", link them via OrderPK (1 side) and OrderFK (many side).

Look at "DemoNormalizationA2000.mdb" (attachment).
Look at Tables, Relationships.

 

[tl mike]

That really isnt my complete structure which I finally figured out what I was doing wrong and got it to work but now my problem is on the (on open event) which I have this append qry setup to work I need it to only append data linked to the OrderPK.

 

[tl mike]

Never mind I totally fergot about the criteria section