Matching Tutor to Student

[JenDambeck]

Hi, Newbee here, I'm not even sure if this is the right part of the forum to post this question, please let me know if there is a more appropriate place for my question.

I have Tutors who teach a/multiple subjects, in a/multiple towns, for a/multiple grades

I need to match ONE student I select who has ONE subject, in ONE town, in ONE grade

I want to find the tutor or tutors who match the above

I "think" I have appropriate tables and relationships set up, but I'm not confident.

In a Tutor table there is a combo box to select subject(s), town(s) and grade(s) - the combo boxes each refer to a table that lists subjects, a separate table that lists towns and a separate table that lists grades

The separate Student table has the same combo boxes.



Do I find the matches with a query? a Filter? particular fields in tables related in the relationship window?

I don't know SQL (yet) so I am using the design screens - but even there I think I am not using the right syntax. I'm beginning to decipher SQL, but it's basic syntax that I'm not following (what is in quotes, where do different punctuation marks go, what needs to be capitalized, that sort of thing) so I may be asking follow up questions about that.

Also, I won't be offended if you point me to a particular google search or webpage to explain this - I'm at a point where I don't know what I don't know, I don't know what question to ask to get the information I need to figure this out.

If this is the wrong place for this question, please let me know and I'll move it to the right area.

Many Thanks!

[davegri]

I think this is an example of what you need, called cascading combo boxes.

Ultimate Dynamic Multiple Cascading Comboboxes, synchronized in any order (accessforums.net)

However, the VBA code is complex for a beginner. None of the lookups are defined in the table, all are in the form and its VBA. The form display does attempt to show how the lookups interact.

[Bob Fitz]

I "think" I have appropriate tables and relationships set up, but I'm not confident.

In a Tutor table there is a combo box to select subject(s), town(s) and grade(s) - the combo boxes each refer to a table that lists subjects, a separate table that lists towns and a separate table that lists grades

The separate Student table has the same combo boxes.

IMHO combo boxes should be on forms but NOT in tables.
Can you post a copy of your db so that we can see what tables and relationships you have.

[mike60smart]

Hi
Can you upload your database?