"Inventory Control" autofill ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
--------------------
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,
 
Back
Top