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

Thanks Edward.

Now in my referential integrity builder should I ignore or restrict my insert? As far as my experience goes it's slim, so bare with me. Using the UPDATE_SQL command how should I go about appending blanks to the tables? I don't have much experience using SQL.

Thanks again

Jon