"Inventory Control" autofill ?

[Granger]

Hi
I'm using the Inventory Control template and I'm trying to get the Purchase Orders Subform t
autofill [UnitPrice] when a product is selected. I have the prices stored in the Products Table.
assume it may be simple, or just my lack of knowledge in this area (beginner)
Thanks
Jaosn Granger

 

[Eric Cárdenas [MSFT]]

Hi,
I'm using the Inventory Control template and I'm trying to get the
Purchase Orders Subform to autofill [UnitPrice] when a product is
selected. I have the prices stored in the Products Table. I
assume it may be simple, or just my lack of knowledge in this area (beginner).
Thanks.
Jaosn Granger

--------------------
You can accomplish this by using a query that joins your Order details
table with your Products table. You then use this query as the recordsource
of your Order details subform.

For an example, checkout the Orders form in the Northwind Traders sample
database.

Hope this helps,