I have a list of 565 parcel numbers in a dBase table, I also have a shapefile containing all addresses/parcel numbers in a given area. I would like to create a new layer from the shapefile based on the corresponding parcel values in the dBase table. PLease note that the shapefile may have multiple instances of the same parcel number, where the dBase table does not. This, in a sense, is like a 1 to M relationship, except I want to create a layer with all the related values for all the parcel numbers.
The only way I can think of doing this is to define a relate based on parcel number, select all features in the current table (dBase) and view related table for all values, then export the related table. However with the dBase table containing 565 values and the shapefile containing over a million values, this is a slow inefficient process. Anyone know a better way?