Obtain Globalids From Another Table

KellyArmstrong — Wed, 09 Jun 2021 16:11:22 GMT

I have a standalone table that has an id field named "media_table_id". I also have a feature class that has an id field with those same values and it has a globalid field. I would like to be able to populate my standalone table with the globalid's from the feature class, where the id's match and contains 'tbl_flare_ends" from the layername field in the standalone table.

Would I need to write an sql to do this? Something like: standalone.media_table_id = feature_class.id_field WHERE standalone.layername = 'tbl_flare_ends' ? Or would I have to do some type of join to populate globalid values that match the criteria?

Re: Obtain Globalids From Another Table

DanaNolan — Tue, 15 Jun 2021 22:05:11 GMT

This sounds like a simple definition query on the standalone table, then a join back to the feature class on your media_table_id field and a field calculation to do the population.

topic Obtain Globalids From Another Table in Geodatabase Questions

Obtain Globalids From Another Table

Re: Obtain Globalids From Another Table