Hello, I am new to access so bear with me. I have an issue with reports getting linked data from a junction table.
As an example, I have three tables to create author - journal references.
AuthorT = AuthorID (primary key)+ AuthorName
JournalT = JournalID (primary key)+ JournalName
AuthorJournalT (junction) = AuthorJournalID (primary key)+ AuthorID (foreign key) + JournalID (foreign key) + JournalNr + PageNr
I create a report with recordsource AuthorJournalT and a textbox containing below
=[AuthorID] & " " & [AuthorID] & ", " & [JournalID] & " (" & [JournalNr] & "), " & [PageNr]
This displays the numbers (ID Values) linked to the authors and journals instead of their real names in AuthorT and JournalT.
e.g. 1 1 3 (59), 65-85
How do you get the report to show the linked AuthorName and JournalName instead of the ID nrs?
your help would be much appreciated