[AccessD] Assistance

MartyConnelly martyconnelly at shaw.ca
Wed Mar 1 18:03:36 CST 2006


Just remember if you prefix or suffix a field name with key, code, ID or 
num,
it will automagically index that field and even duplicate the index if 
declared as a  primary key.
To turn off Tools --> Options --> Tables & Queries --AutoImport on 
Create/Create
delete names

Susan Harkins wrote:

>ID is just the suffix, as in: CustomerID, EmployeeID, OrderID, and so on. 
>
>Susan H. 
>
>I usually don't argue in this list but now I have to.  Do you really want
>one field in every table called ID?  Typing is easy!  Trying to hunt down
>which of 50 fields all named ID is causing the problem sounds like a good
>all-day exercise.
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list