topic Re: Adding related table records in arcgis pro in ArcGIS Pro Questions

Adding related table records in arcgis pro

HamishMills2 — Fri, 10 Nov 2017 03:04:35 GMT

Adding related table records in arcgis pro?

Can't seem to be able to get this to work correctly.... Has anyone been succesful doing this at all?

Using latest ArcGIS Pro and either SDE or FGDB's.

Cheers

Re: Adding related table records in arcgis pro

DanPatterson_Retired — Fri, 10 Nov 2017 04:21:06 GMT

You are referring to these help topics?

Joins and Relates .... and

Add Relate tool in ArcToolbox

pretty well everything is now in ArcToolbox in Pro, so you might want to indicate if you are not using this approach and if you are, what isn't happening

Re: Adding related table records in arcgis pro

HamishMills2 — Sun, 12 Nov 2017 20:26:08 GMT

Hi Dan,

I'm referring to basic user editing. i.e. I want to add a related record in a table already related to an existing point feature class in ArcGIS Pro. For example a company may have a technician visit a point once a month and every month that tech adds a related record as another visit done. Hope this makes sense.

Cheers

Re: Adding related table records in arcgis pro

XanderBakker — Sun, 12 Nov 2017 21:16:37 GMT

You could use Collector for this as explained in this blog (from 2015): Related Tables – Exploring New Ways to use Collector for ArcGIS | ArcGIS Blog

Re: Adding related table records in arcgis pro

HamishMills2 — Sun, 12 Nov 2017 21:19:03 GMT

Thanks Xander, I'm familiar with Collector workflows for in the field, however for an office environment we are wanting to do this in ArcGIS Pro only.

Re: Adding related table records in arcgis pro

XanderBakker — Sun, 12 Nov 2017 21:20:44 GMT

Is the relation between the feature and the related table established through a relationship class? If so you will need a Standard license to edit the data.

Re: Adding related table records in arcgis pro

HamishMills2 — Sun, 12 Nov 2017 21:25:04 GMT

Licensing is not the limitation, currently using Advanced.

Re: Adding related table records in arcgis pro

XanderBakker — Sun, 12 Nov 2017 22:40:05 GMT

I would probably configure a WAB and add the Edit Widget for this, but here goes the Pro way:

In this case I have a featureclass calle "myPoints" and a table calle "myTable" connected together with a relationship class (1:M). Both tables are visualized. I start an edit session, select a feature and activate the table of the points (in the lower section of the screen):

From the Ribbon I activate the Table View ribbon and select Related Data and the related table "RC_pnt2tbl: myTable":

Selection is propagated to the related table and I can new records:

I can activate the Edit Menu and store my edits:

And when I identify the point it will show this:

Re: Adding related table records in arcgis pro

HamishMills2 — Mon, 13 Nov 2017 20:47:13 GMT

Hi Xander,

This workflow does not work for me. Are you entering the related myID field manually or is pro automatically populating this for you?

I can see how, if you manually populate the related field you could simply open the table and add related records freely. For my clients I require a more logical workflow however. i.e. so that you populate the related records directly off of the feature and you do not have to populate the related field.

In any case don't spend too much time on this, it is purely an experimental/learning exercise at this point, and I agree that in the interim I can always get users to use a webapp.

Cheers.

Re: Adding related table records in arcgis pro

XanderBakker — Mon, 13 Nov 2017 21:07:00 GMT

It will be a lot easier to use WAB for this purpose as I mentioned before.

Re: Adding related table records in arcgis pro

Jean-YvesLandry1 — Thu, 01 Feb 2018 03:35:18 GMT

Similar idea but appending two identical hosted layers with related tables. ESRI support has filed it under BUG-000102178.

Hoping for a resolution as this is a fairly common workflow.

Re: Adding related table records in arcgis pro

BerendVeldkamp — Thu, 23 May 2019 12:35:44 GMT

I know this is a very old thread, but since it took me forever to find out how this works, I'll post anyway.

To relate records from two tables that already have a relationship class defined, do this:

Open the table view for both featureclasses / tables
Select the records you want to relate
On the Edit tab on the ribbon, click the Attributes button to open the Attributes pane. The top part contains the selected records.
Expand either one of the records, so that the name of the relationship class becomes visible
Right click on the relationship class, and select Add Selected to Relationship

Re: Adding related table records in arcgis pro

AJR — Fri, 19 Nov 2021 01:44:01 GMT

From the attributes window you can add new records to the related table by right clicking and selecting "Add New to Relationship". This will populate the new related table record with the parent record id value.

Re: Adding related table records in arcgis pro

BugPie — Fri, 03 Mar 2023 16:14:16 GMT

That's what that option does! Viola! Thanks for sharing.. Life in the GIS world I guess. We are blessed to have all this great software that is always expanding, improving so fast sometimes that I don't get a chance to absorb everything as it rolls out and I know that there are all these great functionalities that I just need to "discover". Like this one.

Cheers!

Re: Adding related table records in arcgis pro

IanMackenzie — Fri, 20 Sep 2024 15:29:44 GMT

As of ArcGIS Pro 3.3.0 (and likely earlier versions as well), it is possible to add records on related tables via the Attributes editing tool (on Edit the ribbon). Select an existing geometry feature on the parent feature layer or create a new feature, open the 'Attributes' tool, underneath the selected parent feature's attributes you will find the related table; right-click add new record. Note, the related table needs to be in the map (you will see a warning exclamation mark symbol in the attribute tool if it is not).

Re: Adding related table records in arcgis pro

IanMackenzie — Fri, 20 Sep 2024 15:35:08 GMT

Contributor please select solution. I just posted and then realized several others had already answered the question. Oops. Would be nice if latest replies showed first.