Cascading combo boxes in datasheet form

[gemadan96]

I have a datasheet form list class registrations. The first four columns are used to populate the rest of the columns and have been setup as combo boxes. The first is Location. The second is Student, which is set to only show the students for the location selected in column 1. The third column is Class, which is set to only show the classes available at the location in column 1 . The fourth is Option, which is set to only show the options available for the class selected in column 3.

If I set those columns to display just column 1 from the select query for the combo boxes all the data displays. If I set the combo box to display column 2, the friendly name instead of the ID, only some data appears in the cells of the combo boxes. The combo boxes are all bound to column 1. Each select query is accessing a different table for the data.

Any suggestions on how I can correct this are appreciated.

[gemadan96]

UPDATE: Column 1 (Location) will display the value of column 2 in the select query. Its the Student, Class, and Option columns that won't show all the values in the data sheet. They only display the values of the Location that has focus.

This is with the 2nd, 3rd, and 4th columns displaying the first column from their respective select queries

This is with column 2 set to display column 2 of of its select query. Only the values that match that of the selected record display.