>>Does anyone know when the INSERT trigger fires? Before or after the record is added? My testing seems to be inconsistant, sometimes before, sometimes after. Would there be a way to force the insert within the trigger code so the new values could be read out to the routine?
>
>All regular DML triggers in MS SQL Server are AFTER triggers. The new values are in the Inserted special table.

How about if I'm using a VFP DBC? Is there a way to get to the new values?