Thanks for the addition. The query naming is a good idea! and the PK suffix
can come in handy too.

Lars

"Bob Quintal" schreef in bericht
...
"Lars Brownies" wrote in
:

What's the general concensus about including the tablename in
every field name, like:

tblCustomer
ID_Customer
Lastname_Customer
etc.

Is it necessary? Should it be prefix or postfix?
Thanks,

Lars

It's usually more a hindrance than a help. Except for key fields,
columns should be unique to the database anyways.

I do use PK and FK as a suffix to key column names often prefixed
with the singular version of the table's plural name. I do not bother
with the tbl prefix, but do use qsl, qup, qdl, qtl and xt as prefixes
for queries of types Select, Update, Delete, Totals and Crosstab.

So my tables for a sales system would be Customers, Orders,
OrderLines

Some of the fields in OrderLines would be OrderLinePK, OrderFK,
CustomerFK.

--
Bob Quintal

PA is y I've altered my email address.