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!