Simple 'many to many' search example

Simple 'many to many' search example

Hi, I am trying to find a simple example of a many to may searchable database built with creator.

For my needs, there are a number of 'instructors'. The only details I need are the full name and the postcodes they serve.

Each instructor teaches in a number of 'postcodes'.

Each postcode can be served by a number of instructors. The list of current instructors is a lookup from another form so as to always be current.

In the end all I want the user to see is a search box. They would input the postcode for a list of all instructors operating in that postcode, or they would input the name of the instructor to see all the postcodes that instructor covers.

My search for a simple enough example to follow have been a little fruitless. The employee manager one was far more complex than my needs here, so any pointers would be greatly appreciated.

Thank you