Dlookup last sales price

  • Thread starter Thread starter Abdul Shakeel
  • Start date Start date
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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup for 2 values code 2
sales extended 1
Northwind 2
Primary Keys and Relationships 2
dlookup 1
changing a product price and keeping hisotical data 6
Lookup company invoices (pull down by company ID) 5
FORMS 2

Back
Top