Hi everybody,

Let me give you some info about the problem first: Each year we receive town's data from Assessor's office for each town in MA and bunch of towns in CT. These files may be in different formats and contain data in different coding systems. We have two people, called "Converters", whos job is to convert these files into our database format.

During this conversion they may incorrectly convert some code values into our codes. For instance, the table has BuiltStyle, RoofMat, RoofType, ParkType codes, which descriptions could be found in corresponding Lookups tables.

We have an application, called BldMstr Editor. This application has a form with three pages. First page has a grid with several fields from the table (only essential fields, so no codes) and two other pages show record detail info. The last step of the job is a report, which will show, how many coded fields we have in a file, and if there is incorrect code value, it shows ******** in description. So, converter will see, that he (she) has 70 records with incorrect value in, say, amenities, and now he(she) wants to look up those records.

So, here is the question: how can we filter incorrect codes? Usually these lookups tables contain only few records (less than 15), so we may create arrays for each of them.

So, set filter to not indexseek(BuildStyle,.f.,'BuildStyle','Code) or what would be a good filter expression?

One more complication for Amenities field - this field is 10 char long and it's a concatenation of codes, e.g. ABCUD, where each letter is a code. How would we filter those contain incorrect codes?

Thanks a lot in advance.