arcgis-desktopattribute-joins
I have a ZIP3 boundary feature class that contains roughly 900 records.
I then have a table in a geodatabase that has 21000~ records and a ZIP3 field.
How would I go about making a feature class that has the ZIP3 boundaries for each of the 21000~ records from my table?
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 think a query table will do what you are looking for.
Make sure the table and the feature class are in the same geodatabase.
Open the Make Query Table tool. Add the table FIRST. Then add the feature class. Click ok to create the Query Table. Then right click the resulting layer and export.
Note: I've used this before in 10.1 and it worked fine. Trying now in 10.2 and it's crashing ArcMap. A comment in the knowledge base thread suggests this may not work in 10.2