Luigi D. Sandon wrote: >> The issue then becomes retrieving that value - unless the trigger can >> force the insert to return it somehow. > > > How do you retrieve autoinc fields for other DBs? > There's normally an API to do it, or sometimes you have to execute an SQL command to retrieve it (@@identity on some). Tony