I have a question pertaining to tables and forms.
I have an invoice form that has a number of subforms and the data is flowing very good. The problem i have is with an invoicedetails table subform that has a standard price field. I also have a table "products" that has a standard price field as well. What i want to be able to accomplish is when i choose from a drop menu a product in my form, that it puts the standard price that is located in the products table. I can get it do this, but one may want to overide this standard price. Now if i change the price it will change this standard price in the products table. I don't want this, i want to be able to overide the price just for the particular invoice. I think it has to do with relationships. The relationship i have right now is a one to many from the products.itemid to invoicedetails.itemid.
If more information is required for my problem i will gladly give it. Your help is very much appreciated.
James
I have an invoice form that has a number of subforms and the data is flowing very good. The problem i have is with an invoicedetails table subform that has a standard price field. I also have a table "products" that has a standard price field as well. What i want to be able to accomplish is when i choose from a drop menu a product in my form, that it puts the standard price that is located in the products table. I can get it do this, but one may want to overide this standard price. Now if i change the price it will change this standard price in the products table. I don't want this, i want to be able to overide the price just for the particular invoice. I think it has to do with relationships. The relationship i have right now is a one to many from the products.itemid to invoicedetails.itemid.
If more information is required for my problem i will gladly give it. Your help is very much appreciated.
James