Delete records using another file as filter

[rcorbitt]

I purchase lists of businesses (name, phone, address, etc...) and import them into a FM 6 file. Each list has a SIC and SIC_Name for each business. However, there are some businesses on the list (like city governments, Post Offices, public schools, churches, etc...) that I want to delete or just not import.

I have a FM 6 database "SIC_Delete" containing the SIC and SIC_Name for the records I don't want. How do I use "SIC_Delete" as a filter to delete these records, or just not import them in the beginning? The SIC field contains eight digits; however, the first four are the only ones that matter. For example, I do not want any records where the field value of SIC is in the range of 86610000 to 86619999. (8662 begins a new industry, and may be one that I want to keep.)

Thanks in advance for any help!

Rick

[Fitch]

You could make a relation SIC::SIC from your import target file to SIC_Delete,

and then a calculated field:

SICRelation::SIC

This would evaluate to "1" (true) for matching records. So then Find all the 1's and delete all.