Not sure you'll see a concensus on this, Lars. Some do it. I don't because:

a) JET can handle queries where 2 fields from different tables have the same
name.

b) You can avoid that situation by aliasing the field in a query if it
really matters.

c) In general, if you have tables that have similar field names, you may
want to consider whether the data actually belongs in one table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Lars Brownies" wrote in message
...
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?