The important thing here is that you have recognized the value of UID's as primary keys on ALL tables in a relational database. Using this technique yields enormous flexibility and allows you to easily do this with the database that are nearly impossible without such a design.
To answer your specific question: If you have a real need for each UID to be unique across the whole database, then implement it that way. If you do not have the need for that, then keep UID unique to each table because the implementation choices are MUCH easier and more flexible and yield better performance. FYI, an alternative way of achieving database-wide unique UID's that avoids the need for a single UID source table, is to combine the table-level UID method with a TableID added to each IUD value. __________________________________________________ Delphi-Talk mailing list -> Delphi-Talk@elists.org http://www.elists.org/mailman/listinfo/delphi-talk
