Protecting a lookup value

[spg2112]

Hi all, not sure how to title this one, but basically I have 2 customer tables, one has the unique customer number I want to use when I want to look up the customer on my form that contains the financial data. The problem i run into is when I type in the customer number on the form to look up the record, it obviously changes the customer number in the financial table to that number, and my csutomer numbers are getting all mixed up. Is there a way to lock the number in my financial table?

Steve

 

[Andrew Fergus]

Hi,

I think I answered a very similar problem in this thread.

Let us know if it's not on the right track.

HTH, Andrew.