how to populate field of one table into other

[Serhioromano]

I am sorry I am not an English native, I do not even know term to operate in my particular case, that is why I cannot find an answer with the search. But here is what I have.



tblProducts
- ID
- Name
- Price

tblOrders
- ID
- ProductID
- Price
- Qnt
- Total

In tblOrders.Total is calculated field of tblOrders.Price and tblOrders.Qnt. tblOrders.ProductID is lookup that shows tblProducts.Name and tblProducts.Price but bind tblProducts.ID.

Question, how do i populate tblOrders tblOrders.Price from tblProcuts.Price on tblOrders.ProductID lookup select?

Why I am doing this way? Well tblProducts will have current price. The prices changes very fast with USD rate. Once I create order, price is copied and stick there forever. Even if I change price in tblProducts it will not affect old tblOrders.

Or may be I have completely wrong aproach to this problem? this one looks like very common one. I have created demo database, but somehow all tables are marked with online globe and I cannot switch to design view to see how it is made.

[RuralGuy]

If this thread is truly Solved, do you want to share your solution with others that read this forum or should I just delete the thread?