AnsweredAssumed Answered

Definition Query based on relate

Question asked by rborchert on Apr 22, 2019
Latest reply on Nov 22, 2019 by bullab

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