A
Andrew M
Guest
I am creating a database that models an oil company's orders/sales etc . Some of tables are linked as follows : Oil table linked to customer table[1 to many] which in turn is linked to the order table [1 to many].
I need to store the oil price from my oil table in the order table when I create a new order(through the order form) so when the price changes in the oil table previous order records will still contain the old price. I have tried using the oil price in the oil table as my source for the order form but I can't then get it to save this value into the oil price field in the order table - should I be using a query as the source for the form instead?
Any help gratefully received - this has had me stuck for ages!
I need to store the oil price from my oil table in the order table when I create a new order(through the order form) so when the price changes in the oil table previous order records will still contain the old price. I have tried using the oil price in the oil table as my source for the order form but I can't then get it to save this value into the oil price field in the order table - should I be using a query as the source for the form instead?
Any help gratefully received - this has had me stuck for ages!