The simplest way is to set up validation in the import RAW table.
Create a Value List of your Store IDs. In the Store ID's validation setting in the RAW table, use FilterValues() and ValueListItems() to see if the ID being imported is permitted.
A faster method of that script would be to create a relationship between the Store Id from the raw table and the Store Id from the store table.
Then you don't have to go to the store layout to find the store, you can simply see, while you are on a record in the Raw table if there is any value in the Store::Id field.
If there is a related store there will be, if not there will not.
Then the record can be deleted.
Go to Record/Request/Page (First) (In your Raw table)
If ( IsEmpty ( Store::Id ) )
Go To Record / Request [Next] Exit After Last
This is just off the top of my head. But give it a try.
I'd try David's method first, but if you have trouble getting it to work, you can import your raw data, perform a find to find just the records you want and then import them from the RAW table into your other FileMaker table also.
David's method ended up working for me! I validate the StoreInfo during import and use a ValueListItems check. This made the StoreInfo field Empty for every record that didn't have a related StoreID. Then it was a simple find and delete all Empty!
Worked great! Thanks again!
You can save yourself even more time if you set your field validation to "Always" evaluate. Then those records won't even import.