Updating relationship key fields?

[AndriesV]

Here an attempt to rephrase my earlier post about 'using related fields or copied fields with synchronization issues?' into a more general question. ( I hope that the reason for no further replies isn't the fact that I may have offended 'Old Advance Man' by calling him 'Steven', if so I hope he accepts my apology)

My question:

If a database-file has a field that is auto-entered with a looked-up value (done specifically so that the field-values can be stored and indexed for usage by other relationships to this database-file.) How do I approach the issue of synchronizing changes that are made to the original field that was looked-up for the auto-enter.

At the moment I script the changes to the original field by using a (hidden) layout with a portal for each involved relationship, by 'walking' through all portal rows I update/synchronize the changes. Is there a better or faster or more simple approach for this?

Thanks for your time and help

[Thom]

Use the Relookup script step on the match field that causes the look-up. All look-ups based on this relationship will look-up the latest data. The match field (and the script) are in the file with the fields that do the look-ups.