Jump to content

Open record in another table and verify not a duplicate


This topic is 5697 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

This topic is 5697 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.