Table shows foreign keys instead of related data

[adrian.s]

Hello

Im using LO Base 7.3.5.2 (x64) on Win10.

My table Grades has a field GSubjectID which is a foreign key to to the Subjects table which holds the names of the subjects and the credits that subject gives. In the grades table I would like to see the subject name instead of just the subjectID of 1 etc. How can I do this?

I managed to do it on the form via SQL. Code used : SELECT “Subject” AS “visible”, “SubjectID” AS “Bound” FROM “TblSubjects” ORDER BY “visible” ASC

But now I would like to do a report as well. How can I make it, that I get the subject name on the report instead of just the number of the ID?

I found this related topic but without an answer:

LO-Base: Report with foreign keys?

I have a database with several tables, some of them related to each others with foreign keys. When using the Report Builder, I do not manage to display “related” information. I am only able to display the foreign keys and the value of the other table. Moreover: The wizard (of the Report Builder) does not ask me the table I want to use for the report (but I can change it after in the properties, but only choose one table at a time). The report does not seem to “see” the other tables. I ca…

Thanks
Adrian

[RobertG]

You will need a query or a view for Report Builder. Put all fields you will need in the report into the query.

Have never used the wizard for create a report. But the wizard also asks for a query or a table as datasource.