topic Re: query a relationship class in Spatial Data Science Questions

query a relationship class

DoreenGroth1 — Wed, 01 Jun 2016 17:22:46 GMT

Hi,

For Cemetery data I have created a relationship class between the feature class itself and a non-spatial table. I would like to query the data based on the NS-table attribute "Owner". If the Grave has an owner, than the field "Availability" in the attribute table of the feature should be filled in with the word "sold".

I would appreciate any thoughts, comments and suggestions.

Thanks for your help,

Doreen

Re: query a relationship class

WesMiller — Wed, 01 Jun 2016 17:30:46 GMT

Do your query on the non-spatial table then click the Related tables button and select your spatial table that will select all those related in the NS table to those in the spatial table then you could use Making simple field calculations—Help | ArcGIS for Desktop to calculate the field of the selected to "Sold". It is always best to use field calculator in edit mode so if you make a mistake you can undo or stop without saving edits

Re: query a relationship class

DoreenGroth1 — Wed, 01 Jun 2016 18:54:58 GMT

Thank you so much Wes for your valuable information!!!

Enjoy your day,Doreen