I like Wolfgang's solution better. Beware of using database sequences across a link because if you take one database down for maintenance, the people on the other database may get a really odd error message. Dennis Williams