How can i overwrite the data in my database

[Guest]

Example:
I had a table call 'Order Details' and a order form. When each time i key in
the order product, it's save to order details. And then my invoice will come
out with the customer order product.
Problem occur when the second order and second invoice. It's also same save
the the order product into order details table but when it's come out at
invoice is all the data in the order details. Can i make it only the current
order appear to the current invoice??

 

[Allen Browne]

Open your form (or report?) in design view.
Right-click the edge of the subform control, and choose Properties.
On the Data tab, set these properties:
LinkChildFields OrderID
LinkMasterFields OrderID

There is an example in the Northwind sample database, the orders form.