Many-to-many with checkboxes

Hello,



Just a quick question on the best way to attack many to many joins.



I've a table of Tour Operators, and a table of Countries. I'd like a many-to-many join between them.



I'm using access only as a front end, the tables themselves will be on a SQL server.



I'm struggling to get a decent UI for this. Ideally I'd like some checkboxes. So you could have a form for the TourOperator, and on this for a check box for each country. As you tick / untick the boxes it would need to add / delete a line in the joiner table.



This seems a pretty standard requirement, yet I cannot find any simple way to do this? I've done it before in other systems, just not with access.



I've had a play with using the a option in access for "Allow Multiple Values" when you create a lookup and setting that to "yes". That gives a good UI nice and quickly, BUT as soon as I put the tables on a SQL backend then I loose the option to select Multiple values - it changes it to selecting one item only.



Any ideas for a decent way to attack this to get tick boxes? Any good tutorials to read? Everyone I find shows me how to create the tables & relationships which I can do, but I'm looking at the UI side.



Thanks!



Phil.

Many-to-many with checkboxes