Does anyone know a way to automatically rename related records, based on the scenario below?
All tables contain a 'record name', and that's how the records are related. For example, the record name UUP098 relates all elements below:
Main table record name - UUP098
Notes record name - UUP098
Elements record name - UUP098
Costing record name - UUP098
If I change the Main table record name to UPP110, is there a way to automatically change the Notes, Elements, and Costing tables to UPP110?