Hi I have hit a dead end.
I am currently putting together a report that tracks all of our payments. I am having a few problems though.. I have my main table which includes cust's name, trans no, trans date, product, sku, and cost. I also have another table with field’s product, sku and cost. What I would like to do in my form is have a drop down with the list of products and when the product is selected the other info related to it i.e sku and price is automatically taken from the product info table and placed in to the matching fields within the main table.. This way the price that the product was sold at will also be kept against that order/record.. I think if I use a relational database and the price is changed the price against all previous orders will of course match the new price which I do not want.
Any ideas guys? Getting a bit worried.. I'm running out of time and ideas on this one..
I am currently putting together a report that tracks all of our payments. I am having a few problems though.. I have my main table which includes cust's name, trans no, trans date, product, sku, and cost. I also have another table with field’s product, sku and cost. What I would like to do in my form is have a drop down with the list of products and when the product is selected the other info related to it i.e sku and price is automatically taken from the product info table and placed in to the matching fields within the main table.. This way the price that the product was sold at will also be kept against that order/record.. I think if I use a relational database and the price is changed the price against all previous orders will of course match the new price which I do not want.
Any ideas guys? Getting a bit worried.. I'm running out of time and ideas on this one..
where n is the column number in the combo box. Remember that column numbers are zero based.
