New to Access

[pyep]

I am learning access to try to create a comic book subscriber database. So far I've created 2 tables and a relationship table for those 2 tables.



The first table has a list of names. The second table has a list of comics. The relationship table is a list of which books each person subscribes to.

Is there a way to use that relationship table to make another table or report that utilizes the information there to display the titles and then who subscribes to each title?

For example, Jane, Joe and George subscribe to Batman. On the current table each person has their own column and their books are listed beneath. From that, I want a table/report that will show the title, Batman, at the head of the column with each name listed below. I also want to make it so when I edit the relationship table with the name and each subscribed book, the other table will update automatically to reflect the changes. Is this possible?

[aytee111]

Names table will have an autonumber personID as the primary key.
Comics table will have an autonumber comicID as the primary key.
Third table will contain the personID and the comicID.

Now learn queries. This is the first step. After creating the query and getting it to show the data that you want to see, use the report wizard based on this query to format it and make it look nice.

Forms can also be created where you select Batman and it shows a list of everyone subscribed to that comicID. Using listboxes or subforms, you can do anything you want!