Christian,
I use iID as the PK of every table, and iTableNameID for the FK fields.
The only problem this has ever caused was trying to use Visio to import my database to diagram it, it doesn't handle the relations because of it.
>We are using Visual FoxPro 6.0, and we had a discussion about the Name of the Primary Key field in Multi User tables: Does it make sense to use the same name for all tables (like Prim_Key), or is it indicated to use always a different name for this field?
>The tables should be linked by this field.