Design of lookup table

From: Al Williams <"atwms AT aol DOT com">
Date: Wed, 27 Jul 2005 10:02:23 -0400

I have a lookup table containing single digit, double digit, and alpha characters. I want the combo box to display the information in the sequence that I determine and not sorted alphanumerically. I don't want to use an autonumber primary key to avoid any maintenance problems. I'm thinking about having the PK be a text field as follows:

tblStudentGrade
StudentGradeID	StudentGrade
a		K
b		1
c		2
d		3
....		...
l		11
m		12
n		Adult

Is there a better way to do this?  Thanks.

begin:vcard
fn:Al Williams
n:Williams;Al
adr;dom:;;;Belle Mead;NJ
email;internet:JUNK atwms AT aol DOT com
version:2.1
end:vcard

Follow-Ups:
- RE: Design of lookup table
  - From: Brian

Prev by Date: How do I create a pivot table ???
Next by Date: RE: Changing a linked table to a local table in Access
Previous by thread: How do I create a pivot table ???
Next by thread: RE: Design of lookup table
Index(es):
- Date
- Thread

Relevant Pages

1.0d0 stored as integer?
... Setting a real*8 variable to 1.0d0 somehow creates a memory allocation in which only the single digit "1" is stored. ... gdb will not display all digits of the variable x1 ... But in gdb or totalview, ... end program test1 ...
(comp.lang.fortran)
Re: Fractions
... Can this be accomplished in an excel formula or combination of nested ... Round the result to the nearest 64th; ... it will display just a single digit when appropriate. ...
(microsoft.public.excel.worksheet.functions)
Time entered (and handled as data) in simple minutes and seconds.
... Using Excel 2003. ... How can I get Excel to display and handle entries for duration in minutes ... single digit minutes and ...
(microsoft.public.excel)
Re: Fractions
... Can this be accomplished in an excel formula or combination of nested ... Round the result to the nearest 64th; ... it will display just a single digit when appropriate. ...
(microsoft.public.excel.worksheet.functions)