I would like to reference multiple categories for each book and obviously each category can belong to lots of different books. I want to create a book entry form with a categories subform providing drop down lists for each category he wants to enter for each book.
The access from wizard makes a subform fine if the relationship is a simple one to many relationship between tables. But It didn't give me quite what I wanted when I based the form wizard taks on a queery.
How do I do this?
here are the tables