View Single Post
  #7  
Old April 16th, 2010, 08:35 PM posted to microsoft.public.access
Lars Brownies[_2_]
external usenet poster
 
Posts: 157
Default Include tablename in fieldname

Thanks.

Lars

"John W. Vinson" schreef in bericht
...
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]