"Inventory Control" autofill ?

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

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,

--
Eric Cárdenas
Senior support professional

This posting is provided "AS IS" with no warranties, and confers no rights.