Open record in another table and verify not a duplicate

[josebetzy]

I have developed application for small colleges. What I would like to do is Example: In the form that handles students admission (Student table), to open this same record in the form for Job Placement (JP table), using the social security as the key match element. This script could be triggered by a button. Now I need this script to verify that this same social security is not already exisitng and to open a message of some kind to notify the user that it already exists in the other table or that it opened it should it not already exist.

Thanks in advance

[Ender]

If Student and Job Placement are related, you can test for the presence of a related record using:

If [ not isempty(Job Placement::Student ID) ]

//record exists

End If

Have the script branching add a new record if it does not exist.

However, I'd strongly recommend you do not use the Social Security number as a relational key. This is a bad practice and has several flaws as well as exposing private information to unnecessary risk.

Instead use an auto-entered serial number (Student ID).

[josebetzy]

Sorry for not answering sooner, but being out in a mountain town the Internet service was out about a week. Thanks for answering. Excellent recommendation. Script works fine. Yes I will use an Student ID rather than the SS Number.