>As a general rule you should NEVER have primary keys on dependant data in a table, For Primary keys I always generate a URN type Field ( unique reference number) and other indexes are just Regular type not primary , candidiate or unique
>duplicate table data in a primary key will cause table updates to fail with the error uniqueness of index is violated...

Hi Colin,

We've had no trouble with tables that have a primary key based on 1 field. It's just when compuonding the fields.

URN's are something I'll have to discuss with the DBA. It's an idea.

Thanks
Mike