My $0.02 worth....
Based on what you said and your images,
for the main form, I would use a query on these tables:
Code:
SELECT tblJournalTitle.JournalTitleID_PK, tblJournalTitle.JournalTitle, tblJournalEditor.EditorFirstName, tblJournalEditor.EditorLastName
FROM tblJournalTitle INNER JOIN (tblJournalEditor INNER JOIN tblJunctionTitleEditor ON tblJournalEditor.JournalEditorID_PK = tblJunctionTitleEditor.JournalEditorID_FK) ON tblJournalTitle.JournalTitleID_PK = tblJunctionTitleEditor.JournalTitleID_FK
ORDER BY tblJournalTitle.JournalTitle;
For the subform, I would use use a query on this table:
Code:
SELECT tblJournalIssues.JournalTitleID_PK, tblJournalIssues.JournalTitle_FK, tblJournalIssues.Volume, tblJournalIssues.JournalNumber, tblJournalIssues.PublicationYear
FROM tblJournalIssues;
NOTE: "Number" is a reserved word in Access. I changed it to "JournalNumber".
The form looks like:
(do not/ should not display the PK fields.....)