>You or I may not write this kind of trigger, but I usually work with a SQL-Server database designed by someone else - linking a VFP app to an existing accounting program is my latest project and there are some STRANGE triggers and SPs there.

Barbara,

Just curious, how does this accounting program generate PK's.