7 Replies Latest reply on Jun 22, 2016 3:35 PM by PeterDoern

    Change a table with field names based upon records in another table

    ORSA1965

      Good morning community,

       

      OK.  So here is the ask and if you help me, I will buy you a beer.

      Suppose I have two tables: Table_1 and Table_2.  In Table_1 I have one field named KPI holding three records:

      Health

      Safety

      Environment

       

      In Table_2 I have three field names

      KPI_1

      KPI_2

      KPI_3

       

      I need to change Table _2 field names:

      KPI_1 becomes Health

      KPI_2 becomes Safety

      KPI_3 becomes Environment

       

      Alternatively, Table_2 could be created based on the number and field names of the fields could be a function of the number of records in Table_1.

       

      Help is most appreciated.

       

      Barry Ezell

      +1 757.831.3632

      barry.ezell@gmail.com