I am new to this forum and so far I have managed to find answers to all my questions for my access project.
But I got stuck. I tried various options but they did not work...
I have 2 tables:
T_Product
T_Transaction
where the ProductID is the link.
And 1 query:
Q_Transaction
from which i get the value of the transaction
When i change the buying price in T_Product, depending on the date i changed this price, i would like the price in Q_Transaction to update or not... Because, obviously, last year's transactions have not had their value changed.
I am sure it is a very common topic, but for some reasons, i just cannot work it out.
Thank you kindly for your POVs on this.
Matt