issue with report getting linked data from a junction table.

[Imhotep]

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

[Welshgasman]

You do not use lookup fields in the database. You should use the ID field and join the relevant table by that.
The lookup is actually doing the same thing, but hiding the fact from you.

So remove the lokups and join the tables with respective fields.

[Imhotep]

Thanks for the tip. Fixed it