How to query data from junction table?

[bigal0043]

In access 2010 and it is a web database. Not using multivalued option, using a junction table.




For example lets say I have three tables for a contact database where a person may belong to multiple countries.

Contact
id, name

Countries
id, countryname

Contact_Countries
id, contactid, countryid

I want to have a way for the user to view all the contacts and then select which country then want to only see.

[June7]

Sounds like dependent (cascading) comboboxes. Only seen this done with VBA code. Review: http://datapigtechnologies.com/flash...combobox2.html