If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
designing a magazine/photo index
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 |
#2
|
|||
|
|||
designing a magazine/photo index
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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Lesley" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|