I need a way to verify a user (3) that is login to the database with a group (25) account. My database (DB) was originally created for multiple users that used one group login account. As the DB solution has grown it has become necessary to add and change functionality. One of the features that I've added to a layout field is to enable/disable a "Status" field based on the user so that the field can be edited.
I have 2 copies of the "Status" field on the Layout who's visibility change based on user verification.
It is the method for user verification that I'd like to nail down. I was thinking of using the script step "Re-Login" as a way
to verify the user and allow the Status field to be changed.
I'm looking for suggestions.