Jump to content

Dynamic Field Naming


This topic is 4361 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 4361 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.