Thanks John this sounds like a job for the weekend! I'll post back if I have
any problems.
Thanks agian
Tony

John W. Vinson wrote:
Thanks John and Steve for those suggestions. I think I understand the concept,
I've just done something similar for another of my posts. However, Steve, how
would I create a query that shows all 7 categories on a form when I'm only
holding one value?

You'ld use a Continuous Subform.

It might be necessary to base it on a Query joining the seven-row categories
table to the junction table using a Left Outer Join to show the category even
if that category has not been picked.

--
Why don't my grey cells communicate with each as fast as they used to? I hate
getting old!

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1