Well, thanks for all of your input. Now I'm TOTALLY confused! :-)

I know for myself that when I have used code or in various situations where
I wanted to know what the "entity", I had wished I knew by a prefix.

So, maybe I will just use the simple one and leave it at that.

I will need to look at the links suggested and do some more research!

Thanks again!
--
Thanks!

Dee


"Rick Brandt" wrote:

"Michael Gramelspacher" wrote in message
om...
In article ,
says...
I am creating a database and trying to stick to standard naming conventions,
using prefixes such as tbl frm, etc.

I have come across two definitions of lookup tables - tlkp and tlu - and am
not sure which to use.

I also see tjx for join table and ttbl for title table, but am unclear as to
what these do, especially the title table.

Any guidance would be appreciated!

Do yourself a really big favor and drop the prefix altogether from table
names.

Agreed. I abhor type-prefix naming conventions.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com