>I'd like to know how I can use just database routines i.e a stored procedure or trigger to update a (different) table than the orginal table. In other words I have a table (A) that I add a record or change a field and I want a store procedure or trigger to add a record or update fields in a different table (B) when table (A) is updated. Both tables would be in the same database or not (what ever is required). I would be using VFP 5.0 and not VFP 6.0 to update data.
>TIA
>John

Just create a function that does what you want (in teh SP area of the database)... and then call the function from the Insert/Update trigger. When you modify a table you will find the trigger fields on the TABLE tab.

BOb