ORSA1965

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

Discussion created by ORSA1965 on Jun 22, 2016
Latest reply on Jun 22, 2016 by PeterDoern

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

Outcomes