I have two ideas:
1. You can use identity data type (int data type with indentity property set to "Yes"). You can set also identity seed and identity increment.
2. You can use INSTEAD OF INSERT/UPDATE triggers.
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)
VB (.NET) - what other language do you need in the whole Universe?...
