asteropi
Member
- Local time
- Today, 02:12
- Joined
- Jun 2, 2024
- Messages
- 85
Hey guys
So I want to create invoicing history for the prices.
I have done the same for the addresses and it worked but for whatever reason it doesn't work with the prices
In the Order Details table I created a field called OrderPrice to indicate at what price that product was actually bought and actually create a historical event.
So if change the product price in the Product table, it won't change in the order table.
And in the order form, I used a Dlookup command to get the price from the relevant Order Query. But it just stays blank.
How should I go on about this?
So I want to create invoicing history for the prices.
I have done the same for the addresses and it worked but for whatever reason it doesn't work with the prices
In the Order Details table I created a field called OrderPrice to indicate at what price that product was actually bought and actually create a historical event.
So if change the product price in the Product table, it won't change in the order table.
And in the order form, I used a Dlookup command to get the price from the relevant Order Query. But it just stays blank.
How should I go on about this?