I have the follow FM Tables:
ClientLocationDef is a weekly imported table, containing Client update and new data.. For each ClientAddress there are several ClientLocationDef records. Each ClientLocationDef record has a DefinitionID (1 - 11) where DefinitionID = 7, ShortStringValue = that Clients Address1. If the ID = 8 the stringValue is for Address2, etc.
My question is what is the best way to take LocationDef load table and move the information into the ClientAddress?
2. Make the ClientAddress table fields CALCULATED fields
3. A way I have not thought of
Thanks for the suggestions!
I would say a script is best. However, there are a few ways to write the script. I really like PSOS for doing things like this. Just send it off to the server and move on about what you were doing.