How to set up the relationship when looking for a duplicate
I have a file of active people and a file of inactive people. I want to somehow set up a relationship so that if when creating a new record in the active file, if the new person's social security number exists in the inactive file, then I get an alert that he already exists. If he already exists in "inactive" I could then import him back into "active."
But I can't think of how to get this set up. Any help is always appreciated!
-Jane in LR