In ArcGIS Pro. I have a point feature that contains site locations. They each have a unique LocationID (Maximo Location to be specific)
I have a table that is downloaded from Maximo that contains all the active Project #'s
The projects #'s table contains asset numbers and the device name. There will be multiple unique asset numbers with the same project #
I want to be able to update Install Date and Status on the Project #'s table.
To that end I have created a relationship of 1 (Site Locations) to many (Project #'s) based on Location.
When I start an edit session the relationship works and I can edit the fields I need to edit in the Project # table
However, I have 1606 unique sites. I only have 26 unique location numbers in the Project # table.
I would like to know how I can create a definition query to only show the Site Locations that have a relation
It would work with a Join, but a join will not show a many