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

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

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

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.