May 22, 200619 yr I have patient database with "name" text field and "report" text field. I need a script or whatever, that notifies me that the new patient "name" was there before and to generate previous reports that i can browse easily in the preview mode. Thanks
May 22, 200619 yr Create a script that finds all the records that are the same as the one you are creating. If the name field is enough to check for duplicates, you can use a script like this: Set Variable [$Name; Value: MYTABLE::Name] Enter Find Mode [] Set Field [MYTABLE::Name; $Name] Perform Find [] This will locate all of the records in the database with the same name, including the one you are currently entering.
Create an account or sign in to comment