View Single Post
  #6  
Old April 16th, 2010, 05:12 PM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Include tablename in fieldname

On Fri, 16 Apr 2010 16:41:43 +0200, "Lars Brownies" wrote:

Thanks Allen, PvdG42,

That sounds clear. I'll adopt it.

Now, I have a table called Education and I want a field that holds the name
of the education. Even if 'name' wasn't a reserverd word I wouldn't call
that field 'Name' or 'Description'. In those cases, what do you suggest?


I'll usually use a shorthand version of what kind of name it is: EduName
perhaps.

Another thing I'm doubting is whether to use the plurol form of the
particular word for the fieldname. For instance: in a Customer table should
I use Firstname of Firstnames as field name?


Again, conventions vary, but I'll typically use a plural as the name of a
table (because a table contains multiple Customers), but a singular for
fieldnames (because a customer has only one Firstname).
--

John W. Vinson [MVP]