>>>Hi All,
>>>
>>>My problem is, when I add a new person to my Parent table I also need to add theit Social Security number to about 8 other tables (SSAN is a candidate key). I don't know how to go about creating a custom procedure and modify my referential integrity. Is there anybody out there who have these same requirements and how did you go about accomplishing the task. Using VFP 5.0.
>>>
>>>Thanks in advance
>>>
>>>Jon
>>
>>YIKES!!!!!
>>
>>Are you using SSN as a key????? YIKES!!!! SSN is NOT unique. There are duplicates. I went to college with two people that had the same SSN. Talk about a nightmare.
>>
>They should be unique identifiers for U.S. citizens, but due to fraud/error it's possible to have trouble, as you say...
In the military those duplicates are usually weeded out!
Jon
Jon Paskett
Microsoft Certified Systems Engineer
We all have to start somewhere...
Sometimes over again!