>Do the whole insertions in transaction and use GETAUTOINCVALUE().
>
>If it is SQL Server then prepare the whole script using parameters and use SCOPE_IDENTITY()

The tables are in SQL Server. I think the simplest way would be to what I'm thinking right now - when application starts, it creates vendorsFull (or need to figure out a good name again) table with the triggers. Then in my code I will just use appropriate alias to insert data and the application logic will be preserved (although there are more hurdles with some other tables too).