Dlookup last sales price

A

Abdul Shakeel

In northwind database on orders form is it possible to Dlookup unit sales
price for a specific product from its very last order.
 
P

Piet Linden

In northwind database on orders form is it possible to Dlookup unit sales
price for a specific product from its very last order.  
Click to expand...

Normally you would do one of two things -
either change the price in the Products table and update the Invoice
Line Items table with the current price when doing the data entry or
have a Prices table (ProductID (PK1), EffectiveDate (PK2), Price)
 
Top