arcgis-desktopdatabase-designrelatesrelationship-class
I have been given data from an working online application which consists of a relational model. My aim is to recreate the model using Arcgis Desktop.
I have the table "elements" containing Point geometry with the attribute element_id as the primary key. In the table Aspects, Types and media. The tables "Aspects" and "Media" have a 1:1 relationship with "elements" and media has a 1:m relationship.
It is possible to build these multiple relationships in ArcGIS Desktop?
You neglect to relate the database type.
But the requirement would be that the database would have to be editable, and the user would have to have privileges granted.
edit:.
Since you have stated that you have a fgdb (file geodatabase).
I am trying to understand what you are talking about building a relationship table?
Perhaps you built a relationship class which is not a table but an Esri object for holding a relationship.
If you have an actual relationship.
When you start editing in the spatial table you will see all values from the relate table also.
When you add the spatial object, and input the key value. If the key value already exists, you will see it auto relate.
You can set the attribute prompts and use this tool.
You use the Identify tool to see the 1:M relationship and then you can use the hyperlink.
In this example I have a point dataset called testp which has a relationship with a table called ttp and in this standalone table is a field called HYPERLINK.
Best Answer
You can have related tables in ArcGIS Desktop, but it sounds like what you're really trying to do might be adding Attachments. There are pros and cons to both approaches, particularly if you ever want to work with Server or Online (related tables coming soon!)
Aside from just building the relationships, give careful consideration to how you plan to update and maintain the data.