Design of lookup table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al Williams - 27 Jul 2005 15:02 GMT

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.

Reply to this Message

Brian - 27 Jul 2005 16:02 GMT

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.

> I have a lookup table containing single digit, double digit, and alpha
> characters. I want the combo box to display the information in the
[quoted text clipped - 14 lines]
>
> Is there a better way to do this? Thanks

Reply to this Message