Hi, Any help would be appriciated.

I have an order form with a subform for the parts ordered. The forms are linked. The parts ordered form gets parts information from the parts table (there is also a parts ordered table of course.) Problem is when I change the price on one line (maybe a no charge for that part, it changes any other parts with that number on the same order and in the parts table. I can't seem to change the relationship because the fields are linked?
Thanks in advance for any help you can give.
Lon

The part number price should not be bound to the price list, but to an invoice. That is - build an invoice (or whatever your building) storing the part number, description and price, rather than directly referring to the price list.

The part number price should not be bound to the price list, but to an invoice. That is - build an invoice (or whatever your building) storing the part number, description and price, rather than directly referring to the price list.