Hi, I'm trying to do as follow:
I got a table Quality with
qualityID Grade:
1 0
1 3
1 6
2 0
2 2
2 3
3 0
3 2
3 5
they represent the choice of grades a user can choose depending of the
qualityID (so qualityID1, user can choose a grade of 0, 3 or 6)
In a form, I would like to have:
The list of QualityID formated as Datasheet (not a problem)
A ListBox where they can choose the Grade based on the QualityID
So a form formated as datasheet, the user would see:
TXTQualityID Grade
1 (ListBox with option 0,3,6)
2 (ListBox with option 0,2,3)
3 (ListBox with option 0,2,5)
When a user choose the listbox for qualityID 1, it will dump the
choosen grade in "Dump" table
Thank you for your help
I got a table Quality with
qualityID Grade:
1 0
1 3
1 6
2 0
2 2
2 3
3 0
3 2
3 5
they represent the choice of grades a user can choose depending of the
qualityID (so qualityID1, user can choose a grade of 0, 3 or 6)
In a form, I would like to have:
The list of QualityID formated as Datasheet (not a problem)
A ListBox where they can choose the Grade based on the QualityID
So a form formated as datasheet, the user would see:
TXTQualityID Grade
1 (ListBox with option 0,3,6)
2 (ListBox with option 0,2,3)
3 (ListBox with option 0,2,5)
When a user choose the listbox for qualityID 1, it will dump the
choosen grade in "Dump" table
Thank you for your help