mac | pc Renaming ESS fields

[woodlandtrek9]

Does anyone have any tips for renaming fields that are connected through ESS?

 

According to the ESS tech brief, it seems like this should be possible without an issue:

 

When FileMaker Pro creates a shadow field definition, either when an ESS table is first added to the Relationships Graph, or when the shadow schema is resynchronized with the ESS schema, FileMaker Pro assigns a unique key to each ESS field. As with FileMaker Pro fields, it is that unique key that is used when referring to the field, rather than the field’s name. What is different from the behavior of regular FileMaker Pro fields is that, if the shadow field in FileMaker Pro (not the corresponding field in the ESS table) is deleted, that field’s unique key may be reused. If the schemas are ever synchronized again, the key to the deleted field may be reused, for a different field on the ESS side, and any script steps that pointed to the deleted shadow field will now point to the newly assigned ESS field.

 

So if I'm just renaming the field, the unique key should remain the same, right? When I tried it and synced the tables again, the old field was changed to type "Unknown" and the new name was added as a separate field? Is there any nice way to do this and keep field linkings in scripts and layouts?

 

(Details: The files are hosted by FMS13 on Mac, connected through ActualODBC to MySQL)