Find previous records

[Dr.Hamed]

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

[John Mark Osborne]

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.

[Dr.Hamed]

Thanks. This script does it.