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