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 

Outcomes