I need to create duplicate features (in this case parcels), using a related table to populate ID fields. In essence, I need to use a related table of parcel owners to create duplicate parcels, each with its own unique ID from the related owner table. The related table already contains the many-to-one link to parcels, I just want to force a one-to-one relationship between the owners and parcels, by creating a duplicate parcel for each owner record.
I've just done it with our parcel-feature and owner-table.
i made a join on the Parcels to the Owners, and selecting "Keep only matching records" - right after the join - make a "Copy Features" from the ArcToolbox - and it will make duplicates of all parcels where there are owners for it.
In ArcMap 10, use the MAKE QUERY TABLE. First, make sure the table and feature class are in the same geodatabase. The MAKE QUERY TABLE tool will create a feature layer so you'll have to use COPY to create a permanent feature class. You can then export this feature class to a shapefile.
We use a spatial view in SDE to achieve a similar result. In our case it is because we have parcels with multiple owners (condos, townhomes, etc.). We import a file into SDE on a nightly basis that contains all of the property owners in the county, each with unique id that relates back to a specific parcel. We create a spatial view using this table and our parcel polygon feature class. The result is a spatial view with stacked parcels, one parcel for each individual owner. When you identify this layer in ArcMap, you get a result for all of the owners. We are at Arc 9.3.1. This layer has been very beneficial for our tax department.
You join your owner table to your parcel table with the keep only matching records option enabled.
Use the Copy Features in ArcToolbox (Data Management Tools -> Features) to copy your parcels to a new Feature Class. The new Feature Class contains every parcel one time per owner, meaning that if a parcel has two owners, the parcel will figure two times in the new Feature Class - it is simply dublicated with the Copy Features Tool.
All this you can put in to a Model in Model Builder - You find Add Join under Data Management Tools -> Joins. The Model can then be run every time, that your base data are updated.