var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Database design/layout question - please help!
I'm working on creating a searchable database for about 4000 heirloom family photos and documents, using Access 2002.
I'm currently useing two "main" tables, the first to include:
link to image
The Second table will be used for "subect info" and contains the following fields:
Date of birth
My question is what will the format and the relationships look like by adding the third table that will tie the first two together?
First, it's a bad idea to use the octathorpe "#" in your field names. This is an Access reserved character and it can cause oddball errors later on.
Second, your third table can simply be a cross-reference table of photo to subject. You just need three fields, maybe 4:
SubjectPhotoID (primary key autonumber)
SubjectID (foreign key)
PhotoID (foreign key)
Description (text, description of subject in photo)
Then you will have a one-to-many relationship between tblSubject and tblSubjectPhoto, and a one-to-many relationship between tblPhoto and tblSubjectPhoto.
Hope this helps,
talking of field names, you may also save yourself some [bracketing] problems later on by not using spaces: LinkToImage is just as easy to read.