>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

You can open Parent Table Properties (in Table Designer) and put your custom stored procedure name into Insert Trigger Box. Then you open Stored Procedure editor and write your custom code (under this procedure name) to insert values into appropriate tables (I guess it should be some UPDATE_SQL commands). It's a good idea to have some customized error messages when you return .F. from trigger.