Relationship Class - Edit to Add Feature / Record to All Layers / Tables

TimDonoyou — Thu, 05 Sep 2013 15:21:12 GMT

Hi All,

I am just investigating Relationship Classes and am trying to figure out if it is possible to...when editing and creating new features to add the new record to all related layers and tables...?

For example, we undertake surveys of ponds for newts, frogs and toads which require more than one visit so we have a polygon feature class of our pond locations and then tables of results for each visit. For existing, known ponds the relationship class is great and means when clicking on a pond we can expand the + and see results for each visit.

However, when we come to add a new pond it needs to be added to all 6 layers which is quite time-consuming and allows potential errors with incorrect PondID being entered in each table.

Therefore, is it possible to add the pond polygon to the featureclass, add the PondID and for this to then automatically create a record in each table which inherits the same PondID...?

Any pointers much appreciated

Thanks

Tim

Re: Relationship Class - Edit to Add Feature / Record to All Layers / Tables

TimDonoyou — Sat, 14 Sep 2013 22:20:08 GMT

Hi All

Just in case anyone is interested I solved this by creating a python script tool which takes a featureset input for the pond and a text parameter for the pond id and then uses insert cursors to add a row to all required tables.

Hope this helps someone else

Cheers

Tim

topic Re: Relationship Class - Edit to Add Feature / Record to All Layers / Tables in Data Management Questions

Relationship Class - Edit to Add Feature / Record to All Layers / Tables

Re: Relationship Class - Edit to Add Feature / Record to All Layers / Tables