Unique ID database wide
I'd like to know if anyone has developed a way to create a unique Id for each record--through out the entire database, not just the record's current table?
I'm working with someone who already has a database I'll be periodically importing too. He has a script he uses when a new record is created. A new serial number is generated( i think this is his serial number table), then the number is automatically inserted in new record. Perhaps there is a way I can have a script run everytime a record is created?