Change Field Names based on data in another table

Document created by ORSA1965 on Jun 22, 2016
Version 1Show Document
  • View in full screen mode

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

Attachments

    Outcomes