1 Reply Latest reply on Mar 11, 2016 9:47 AM by bigtom

    Suggestion on how to update a table

    gregdc

      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