Linking three tables: Journal, Journal Editor & Issues

[snowboarder234]

tblJournalEditor
tblJournal
tblJournalIssues



Ideally, all 3 tables would link to each other, but only JournalIssue and JournalTitle are linking and even that looks a little sketchy.

Journal and journal editor or 1 to 1 relationship, if I understand this clearly. Journal has one title, editor of journal has one name = one to one relationship.
Journal issues should link to it's respective journal title, ie; one to many since one journal has many issues.

[ssanfu]

Journal (title) and Journal issues relationship seems OK.


If Journal and journal editor (tables tblJournal & tblJournalEditor) have a 1 to 1 relationship, why do you have 2 tables? Shouldn't they be 1 table?

Can 1 Journal title have many editors?
Can 1 editor write for many Journal titles?
If both are yes, you need a junction table.


What does your data look like? If you try and enter the data into the current structure, does it fit/work?




BTW, "Number" is a reserved word.......

[orange]

In addition to Steve's comments, I 'd like to see a few sample records and a brief description of WHAT each of these tables represents.

[snowboarder234]

Thank you Snafu and Orange. I eliminated the 3rd table and set up a junction table. I watched a video that said one to one relationships should not be indexed so, in design view, I set the Index to No on the JournalEditor and JournalTitle tables.

[ssanfu]

I would not have a compound PK field in tblJunctionTitleEditor.
See last paragraph - "Don't use Primary Keys to Prevent Duplicate Records"
http://www.fmsinc.com/free/newtips/primarykey.asp


I would have


About your picture.....
You did see the asterisk to the left of the "JournalEditor_ID" (and "JournalTitle") field(s)???? (red circle)



The asterisk means it is a NEW field..... it wouldn't have anything to display until you typed it in.

I always set the Subdatasheet Name property to "NONE" because I always use forms........

[snowboarder234]

I'm sorry I didn't provide you with the additional screen shots -- the data fields had been filled in -- that's why I don't understand why it doesn't appear in the datasubsheet. That makes me very concerned that the editor will not match up with the correct journal. As a newbie, I rely on the subsheets to let me know the relationships are as I intended.


The other thing that is of a concern is there are MANY issues of one particular journal, resulting in duplication of the journal title repeatedly. Almost seems like there should be a table for each journal?