comparing a user to existing users

[Djuans]

I have a FM7 database with two tables, one for Teacher Info, one for Service Choices that teacher might sign up for.

I would like the user of the database (eventually to be a web-based tool to allow teachers to request/track multiple services) to be able to type in their email address, have it compare to existing email address records (in the email field, Teacher Info table), find the matching one and open that r teacher's record. If it doesn't have a match, open a new record with their address aready in the correct field.

Any ideas for me?

Thanks,

 

[JeanW]

1. Do it manually
2. Write down your steps
3. Make a script
4. Do the errortrapping
5. done