Fill table fields according to the field name

[almontaser92]

I have a table named "SourceTable" that contains a field for the employee number and a field for the field name and a field for the value of the field in the second column and another table with the name "tblEmpData" and I want to fill each field in it based on the value associated with its name in the first table
Can this be done using code?

[Welshgasman]

What a strange request

Yes. I would use the source table as a recordset.
Loop through the records building a sql string (probably two TBH) until the employeeID changes.
When it changes execute the Insert/Update sql

Rinse and repeat
You could do one field at a time, but very inefficient, if easier to code.?

[Welshgasman]

Crossposted https://www.utteraccess.com/topics/2062866?post=unread

[orange]

???Confusing request??
Perhaps you could describe what you are trying to achieve and why you decided on the approach you posted.

[Welshgasman]

???Confusing request??
Perhaps you could describe what you are trying to achieve and why you decided on the approach you posted.

Several replies and modified DB uploaded on crossposted site

[Welshgasman]

Now appears solved on the crossposted site