Design of lookup table

  • Thread starter Thread starter Al Williams
  • Start date Start date
A

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.
 
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.
 
Back
Top