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]
|