Does anyone know of a way to script in an "Approval" workflow for changes made to records in a database?
As a simple example, I have a table called CLIENTS with a Name Field and Phone Number Field that is accessible by multiple users.
If User A makes a change to the phone number field, I would like User B to approve the change.
I have a couple of ideas, but they get very cumbersome from a scripting perspective very quickly. I thought I would see if anyone out there has had any success with this kind of workflow in FileMaker?