Question Store Current price of item

[rambo12]

Hi,

I have a table holding all product information like its price.

I also have a table for orders & order lines. How can i store the price of the product at the time of ordering inside the order line table so that they do not change when the product table is updated i.e price increases?

Could someone point me in the right direction and tell me what im looking for?

Thanks

 

[Rabbie]

Hi,

I have a table holding all product information like its price.

I also have a table for orders & order lines. How can i store the price of the product at the time of ordering inside the order line table so that they do not change when the product table is updated i.e price increases?

Could someone point me in the right direction and tell me what im looking for?

Thanks

In my orderline records I store the quantiy and the Unit price at the time of ordering. Other details such as description can be got from a link to the products table. Infact I populate the orderline.UnitPrice from the products table but by doing it this way I can always calculate the actual price regardlss of later changes.

 

[rambo12]

how do you store the unit price at time of ordering. Sorry not very good in access

 

[HiTechCoach]

Hi,

I have a table holding all product information like its price.

I also have a table for orders & order lines. How can i store the price of the product at the time of ordering inside the order line table so that they do not change when the product table is updated i.e price increases?

Could someone point me in the right direction and tell me what im looking for?

Thanks

Have you looked at the Northwind sample database that comes with Access? It shows a way to do this.

I have attached a copy just in case you need it.

 

[rambo12]

got it... thanks guys. Found the example and put together my own code and it worked!!!

thanks

 

[HiTechCoach]

You're welcome!

Glad we could assist.