DON'T WANT TABLE TO UPDATE WHEN CHANGING FORM FIELD

[yimi]

Hi, This cannot be that difficult. What am I doing wrong?!?!?

I have an order subform that contains product details. IE product name, cost,etc. I have a drop down on the subform so that the product can be selected and the price of the product populates. All fine and dandy. The problem is I would like to be able to change the price of the product in the subform without the Products Table changing.

What is happening is when I change the price from $50 (price on the table) to $15, the table price changes to $15 and all records on the form that have that product also change to $15. I only want to be able to change the price for that particular record.

What the #$#$( am I missing?

Thanks for any help

 

[snoopy75]

Sounds like you've got some one-to-many relationship defined that connects the product with the price. If so, then it would make sense that changing the price of one product would change it for all of them. If you want to be able to change individual records, then you'll need to de-normalize your database a little bit, and put the price on the "many" side of the relationship.

Hope that makes sense.

--Ryan