Automatic Field Population

[harleyhead]

I am sure this has been done a thousand times - but not by me. The application is Sales Order Entry. The area is sales order line items. To keep it simple for this discussion: The sales order line (SOL) has:

Sales Order #
Sales Order Line #
Part Number
Unit price

I have a query for a subform that contains:

SOL.Line # SOL.Part Number Part Master.Description SOL.Unit Price

What I want to do is that after the Part Number has been entered, populate the Unit Price both on the SOL row and have it reflected on the subform.

I know this could all be done using an update query and macros, but it just isn't coming together.

 

[FoxProProgrammer]

Where does the user enter the part number and how is it related to the rest of the data? What is the structure of your table? You can probably use an Update query, but I don't understand enough about the situation to suggest anything. dz

 

[harleyhead]

The sales order line is as stated in my first message. The part master contains:

Part Number
Part Description
Unit Price

The SOL table is linked to the Part Master on the Part Number (one to many - Part to SOL).

The query for the subform is as stated in the first message - a simple fill in for the description. However, I do not have the Unit Price selected from the Part Master since I want the one on the SOL to be populated based on the Part Master and not just have it displayed like the description.