I am having some difficulty attempting to write a script for auto-populating a unique ID field from one table to another table in Studio.
I have a Post feature class, sign table, and signsmaint table. The Post and Sign and Post and Sign Maintenance are bound by a relationship class, but the signs and signsmaint tables do not have a relationship class. I am looking for a solution to get a field "SignID" to populate when a maintenance record is created in the signsmaint table (field is "SignsMaint_ID").
I currently have a sequentially incremented number in both the Post and Signs table, but I am trying to pull the SignID from the Signs table to populate into the SignsMaint_ID to the signsmaint table.
Any ideas on this would be greatly appreciated.
Thanks!
