In Access 2007 I have a Many-To-Many relation set up between Products and Categories (with a Products_Categories_Spec junctiontable between), so one product can have many categories and one category can belong to many products.



I'd like to make a Form where I can easily set the categories for each product without having to deal with the ID numbers, which is the case when just using the "make Form Wizard".

How is this possible without using the "evil" lookup function?