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!