A Abdul Shakeel Oct 13, 2009 #1 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.
P Piet Linden Oct 13, 2009 #2 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)
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)
