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