AnsweredAssumed Answered

Suggestion on how to update a table

Question asked by gregdc on Mar 11, 2016
Latest reply on Mar 11, 2016 by bigtom

I have the follow FM Tables: 

FM_Table Information.PNG 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?

1.  Script?

2. Make the ClientAddress table fields CALCULATED fields

3.  A way I have not thought of

 

Thanks for the suggestions!

Greg DC

Outcomes