designing a magazine/photo index

[Lesley]

I'm trying to design a database that will list all photos of an item in
multiple issues of several magazines.

I'd like the output to show either, item, which issues of which magazines
and what pages, there can be more than one page in a single issue.
I'd also like to show what items are in an individual issue by page.

Any help would be appreciated. Thanks

 

[Arvin Meyer [MVP]]

You'll need at least 3 tables:

1. tblItems
ItemID
ItemDescription
other fields which may describe the item

2. tblMagazines
MagazineID
MagazineName
other fields which may describe the magazine

3. tblMagazineItems
ItemID
MagazineID
MagazinePage
other fields as necessary

the 3rd table creates a many-to-many relationship since 1 item can be in
many magazines, and in many pages of 1 magazine, and 1 magazine can have
many items.