If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup table naming convention
For design simplicity, all of my lookup tables have two fields, an autonum
for the primary key and text field for the value. Example: tblPriority PriorityID: Autonum Priority: Text where the priority is "ASAP", "Normal", and "Low". Assume tblWorkOrder includes a link to tblPriority. What do you name this field? Priority or PriorityID? Best, Christopher |
#2
|
|||
|
|||
I always name fields with the first three characters unique to each table.
For instance tblWorkOrder would have fields like: worWOrID worOrigDate worTitle worStatus worPriID 'link to tblPriority.priPriID This suggests that no two fields in an application have the same name. All primary keys consist of the first three characters repeated followed by "ID". This system has worked very well for me. -- Duane Hookom MS Access MVP -- "Christopher Glaeser" wrote in message ... For design simplicity, all of my lookup tables have two fields, an autonum for the primary key and text field for the value. Example: tblPriority PriorityID: Autonum Priority: Text where the priority is "ASAP", "Normal", and "Low". Assume tblWorkOrder includes a link to tblPriority. What do you name this field? Priority or PriorityID? Best, Christopher |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 05:01 PM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |