Design of lookup table

[Al Williams]

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.

 

[Brian]

You've got it: add your StudentGradeID and then manually enter the order you
want to see. In the RowSource of the combo box, make StudentGradeID the first
column & sort by it. Set the bound column to 1 and column widths of 0;1
(adjust the width of column2 to acccomodate the visible items on your list.
Then, the user will see the StudentGrade field, but the combo box will be
bound to StudentGradeID.