>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).
If it's not broken, fix it until it is.
My Blog