Topic: Using a linked field
I am using a Dictionary table in my database to have conformity between my records as there are only a few choices in that field. When I created my Report all I get is a number for the results in the column for that field.
SELECT
Figures.Number,
Figures.Name,
Figures.id_tblFactions
FROM Figures;
Where the third column (Figures.id_tblFactions) refers to the Foreign Key Field in the Figures table. This set up only gives a number in the report for the faction.
What am I missing? Thanks