data changes in look up file after entry in portal

[landscaper]

Good Morning,

When I enter an item # to do a look up for name, size and price of an item that is entered into a portal, if the item does not have a price because it varies from invoice to invoice, the manually entered amount on the invoice getis entered back to the look up file, so the next time that item # is entered, it brings up the previously entered amount. I want it to remain empty.

What have I missed in setting this up so it won't do that?

thanks

LJ

[Fitch]

It sounds like you might be relating your invoice directly to your products table. You should have a separate line items table, which would look up prices etc from the products table.