• Registered: 2014-05-08
  • Posts: 3

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

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Using a linked field

Hello,

You must combine two tables, Figures and tblFactions

corrected SQL query:

SELECT

Figures.Number,
Figures.Name,
tblFactions.fieldname

FROM Figures

LEFT OUTER JOIN tblFactions ON tblFactions.id = Figures.id_tblFactions

where fieldname is field you want from the table tblFactions

Dmitry.
  • Registered: 2014-05-08
  • Posts: 3

Re: Using a linked field

That did it, Thanks!