Hi Jim ----
This is true in the world of true databases and ERDs. In that realm, to tie together entities you have to have the exact same column names. IE, Oracle Designer 2000 dislikes different related key column names.
But we're talking Fox here. Most of our relationships are hard-wired in code (nobody *seriously* uses the DBC RI) and can, therefore, be flexible.
I reiterate that I like to use PK and FK for keys for convenience; I use no other prefixes.
>
>Just to add my two cents in here. I don't use the two char prefix on table field names. My primary reason is trelated to PK and FK situations. I believe that if there arte two fields that share the same domain they should have the same name. A PK and FK by definition share the same domain, therefore they should have the same name. Using table prefixes precludes the two from having the same name.
>
>Taking that position a step further, if some of the fields don't follow the prefix convention then that convention is not being used conssitently. A convention that is not used consistently is not very valuable.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05