What you are trying to do is called mapping.
You have table 1 with info on photos and table 2 with info on various photo types. You will create table 3 that will have two entries per record and it will be photoID and photoTypeID.
So once you have request to show all landscape photos you query table 2 of photo types to get ID of landscape type. Then you can query mapping table to get you information on ID of photos associated with this type of photo and with result from this you can pull data from table 1 on selected photos.
Moderator
Featured Poster
Reputation Points: 2786
Solved Threads: 874
Code tags enforcer
Offline 6,659 posts
since Dec 2004
Unsolved 
