Comic Collection DB

[kevinv]

Please forgive me but I am new to more advanced databases. I am trying to create a comic book collector database. I want to have the issue numbers correspond to titles, and other info that pertains to the specific issue such as condition, location, etc.

Is it possible to have a title and then in the layout and then add, or use a check box to check off the issues that you have? Then the info for the issue shows in the layout.

So lets say you enter a title of Spiderman. It has an id of 1. off the the side you have or can enter the issues you have, maybe on separate lines. Then if you click on the issue one record you can enter all the info for it. Click on Issue 2 and you can enter new info that is tied to that issue.

I am going through tutorials but its tricky and I want to see if its possible before I really kill mysef on it. Any help or examples of how to set something like this up would be great. Thanks a lot.

[The Shadow]

Here's a quick example I threw together for you that demos how this might be done.

Comics.zip