I have a form called 'Form' with an unbound Combo Box on it called 'Item'. There is also a select query displayed right on the form that feeds from a table called 'Table'. Each time you select a different value in the Combo Box, the query refreshes. The value in the Combo box is used as...
I have two tables that look like this:
Table 1
Session Group Trainer
A 1 John Doe
A 2 John Doe
B 1 Jane Doe
B 1 Jane Doe
Table 2
Session Group Trainee
A 1 John Smith
A 1 Jane Smith
A 1 Robert Jones
A 2 Sally Jones
A 2 Steven Williams
A 2 Rebecca Williams
(and then entries beyond this, you...