I am working on a personnel database and am trying to create a script that logged any changes to employee information.

What I am looking to do is dynamically select a field name. I think I can do this with set field by name, but I just can't figure it out.

I have 3 global fields.

g_olddata

g_newdata

g_fieldname

1.) I have a script trigger that when you select a field it displays a dialog box asking if you want to change the information if you enter the new ( let's say phone number ) and copes it into g_newdata

2.) it gets the active field name and copies it into g_fieldname,

3.) gets the active field contents and copies it into g_olddata.

4.) sets the g_olddata into a field on another table

This is all working. The issue that I am having is I want to set the contents of g_newdata into the field name that is stored in g_fieldname. I think that set field by name function will work, but I have been unable to figure out the proper syntax.

Any help would be greatly appreciated.

Justin

Another Ray Cologon technique to the rescue. UltraLog