Skip to Content
0
Former Member
Aug 04, 2015 at 07:32 PM

Retrieve data from joined table

17 Views

Hello,

I hope someone can help me with this (probably easy) question.

I have 2 tables: tblJob and tblStatus

tlbJob:

  • tblJob.JobId
  • tblJob.JobDescr
  • tblJob.PrevStatId
  • tblJob.NextStatId

tblStatus

  • tblStatus.StatusId
  • tblStatus.StatusDescr

Both fields PrevStatId en NextStatId link to the same table, via the key StatusId

In CR2013, I want to create a list, and have following fields in the details section:

tblJob.JobId; tblJob.JobDescr; tblJob.PrevStatId; tblJob.NextStatId

But instead of the Status ID's, I would like to see the Status Description in the resulting list.

I can't figure out what to do to achieve this, since both JobStatus-fields link to the same field in the tblStatus.

All goes well when I do this with just one Status Description...

Thanks!