Change Field Names based on data in another table

Version 1

    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

    bezell@innovativedecisions.com