User Change Field

[Leather Knight]

I have a field that makes a Client ID by taking data from the info inserted. It creates a unique id. However I would like to have the end user be able to change it if they have to use a specific id already in use. Maybe a button that pops up and asks what they want to use as an id for that client. any ideas??

Thanks

[JerrySalem]

You can make the field on the layout a button.

When you click on the button it the script can first check if the user has permission to change Client ID.

If your permission allows, display a dialog box with the Client ID field, and a message.

Clicking the OK, button, checks that the ID is unique or fits any other criteria. If it dosn't pass, display the dialog again. (use a loop to do this)

when the client ID passess, you can commit the record.

Is this what you want?

Jerry

[Lee Smith]

We have had several discussions about Client IDs, and allowing clients to play with them.

Be aware that if you allow the clients/users to enter, change, modify, delete, any IDs., do NOT use that Field for Relationships, etc., or you will have many problems.

Lee

[Leather Knight]

I know Lee, but this specific database will have to have that option. I cringe at allowing it to be changed, and may just say no to it. But think I will try and see if it does what is needed.

Yes Jerry, that is the general idea. I was thinking of a button that pops up a window that allows them to change the ID, but maybe make it so it is automated with the option of user override, this may be easier.