arcgis-9.3arcgis-desktopconvertrelates
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'm using ArcGIS Desktop 9.3.1.
It's sometimes confusing, but it's really a matter of perspective. See this diagram (from this topic) for a reference:
This is an example of five relationships (and three different cardinalities).
As you can see, whether a relationship is one-to-many or many-to-one depends on how you look at it.
All that being said, the easiest way to accomplish what you're looking for is to create a query table that creates many identical parcels, one for each mobile home. See this blog post for more details: A quick tip on performing a 1:M join
If all of your data is in an enterprise geodatabase, you could also use a Query Layer to do the same thing, on the fly (no intermediate feature class).
You can use [Make Query Table] Tool in ArcToolBox:
After tool execution,You can find a temporary layer in the ArcMap TOC windows.It should that contains the shapes of each datetime.You can export layer to save it to feature class.
Best Answer
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.
It worked for me.... finally...