Relationships

[Lon425]

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

 

[llkhoutx]

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.

 

[llkhoutx]

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.