Price auto value

[stoicy]

Hello all

I put the price in my database manually.
I need it to be automatically but I am afraid if I change the price in the future, it will effect my saved records.

Please help

 

[Gasman]

So you either store the price for a date range, or lookup the price at the time of data entry and store it, so it does not change.

I tend to do the latter, just because it is easier to implement.

HTH

 

[Tieval]

What you need to do is store the price with the order when you enter it but to take this price from a table of current prices.

Basically have a table of current prices which you can update as and when prices change. When you add an order, you can enter the item on the form and default the price to the current price and store it in the order.

This way you have the price at that date and it will not change in old orders when the current price changes.

Gasman, we crossed

 

[stoicy]

What you need to do is store the price with the order when you enter it but to take this price from a table of current prices.



Basically have a table of current prices which you can update as and when prices change. When you add an order, you can enter the item on the form and default the price to the current price and store it in the order.



This way you have the price at that date and it will not change in old orders when the current price changes.



Gasman, we crossed

I do t know how to do it. Could you please give more details or can modify the attached file
Thank you

Sent from my SM-N900V using Tapatalk

 

[Gasman]

Use a DLookup to get the relevant price and store it in the record.

 

[stoicy]

Use a DLookup to get the relevant price and store it in the record.

How? Could you please explain

Sent from my SM-N900V using Tapatalk

 

[stoicy]

Use a DLookup to get the relevant price and store it in the record.

How? Could you please explain

Sent from my SM-N900V using Tapatalk

 

[Gasman]

How? Could you please explain

Sent from my SM-N900V using Tapatalk

See this link https://support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937

It can explain it much better that I could and has examples.

 

[stoicy]

See this link https://support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937



It can explain it much better that I could and has examples.

Thank you so much Gasman

This link help me to solve it
[emoji8]

Sent from my SM-N900V using Tapatalk