Combobox from a Junction Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Combobox from a Junction Table

David Sovis

2 years ago

I have a many-to-many relationship Tutor Table and a Student Table with a Junction table that "pairs" the Tutors with the student. the relationships are defined by comboboxes on both Tutor and Specialists forms via subforms. This works well. But, what I am stumbling with is I need to use the pairing relationship to drive a combobox that identifies the student on the time and feedback form (driven by a Tempvar for the Tutor's ID). This combobox needs to only show the students paired with the Tutor so the Tutor cannot see the other students not assigned to him. I can create an aggregated list of students, but, I can't sort it so that only the paired students show in the combobox. Any suggestions would be helpful....hopefully, this is my "last hiccup", so to speak...

	Adam Schwanz @Reply 2 years ago
If you're struggling with the Row Source on the combo just go make a query, set the criteria and stuff like you need, confirm it works, and either save and use that query as the row source, or under view go to SQL view and copy that into the Row Source.

	David Sovis OP @Reply 2 years ago

	David Sovis OP @Reply 2 years ago

	David Sovis OP @Reply 2 years ago

	David Sovis OP @Reply 2 years ago
THis is what I have and the list currently shown all students and not showing only students paired with this tutor. I feel like I need a WHERE or HAVING somewhere, not sure where or how to show only the tutor's students... Thank you so much for looking at this, you guys are the best!

	John Davy @Reply 2 years ago
Are you trying to show the students only for the Tutor (is that Specialist?) ? If so, you will need to use a WHERE to limit your list to only those with that Tutor's ID. John

	David Sovis OP @Reply 2 years ago
John, Yes I need to limit the students to only tutors (Specialist) that are assigned. I am not sure where to put the WHERE clause...

	David Sovis OP @Reply 2 years ago
I got it! I was stupidly trying to put the condition it in the wrong place of the expression. MY DATABASE IS NOW LAUNCHED (on ADC) and is going through first round user testing. Thank you to everyone on the Access Learning Zone team for all of your mentoring, suggestion and help! You are all awesome!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View