Query Field Fill-In Automation

[dmaach]

I know there is a way to do this, just trying to figure out how!



Easiest way to explain this is imagining a database to track retail sales.

You would setup the following tables:

Orders
+ Order Number
+ Customer
+ Order Date
etc

Order Detail
+ Order Number
+ Part Number
+ Quantity

I know there would be more tables and fields involved, but for my question this will do.

Know pretend you want to setup a query (then going to a form) for entering orders.

What I want is a way that the order number would only have to be entered once and then fill in automatically for each line item. (Basically eliminating the user from having to enter the order number on every line).

I know this is probably something easy, but have been pulling my hair out.

They do this on the Northwind sample database, but I can't seem to find how they make it happen.

Thanks.

[pbaldy]

Typically that would be displayed with a form and subform. The master/child links of the subform control would accomplish what you're describing.