Access 97 subform to input data into "many to many" relationship

[akohl]

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

books_table
book_id
book_nam

books_categories_table
book_id
category_id

categories_table
category_id
category_name

[DLG_1]

you shouldn't have this type of relationship, it screws things up. you should have an intermediary table that contains keys for both tables....and keep info that way.

[westmich]

Originally posted by DLG_1
you shouldn't have this type of relationship, it screws things up. you should have an intermediary table that contains keys for both tables....and keep info that way.

I believe that is what the middle table is.

You have a many-to-many relationship defined, each book can have mutiple categories and each category can have multiple books. Not sure what you're asking/needing.

[DLG_1]

akohl,

why don't you post what you're trying to accomplish, not the task, but the why of what you want. I'm sure that there is a solution to that.