I am changing a table so that it now depends on the values of two fields instead of 1 (an item code (6 chars) and a site code (1 char).

In add mode I can use infoseek to see if a record exists and if it does go back to item code field and display a message to re-enter or exit add mode.

In edit mode I want to only check if a new site code is entered. I know I can defne a property to assign the original value too. My question is what is the best place to save the initial value of site code (i.e. which method) since it has to change when going into edit mode for that particular record? Edit mode is entered via a button. Should it be the init menthod of that button or something else?