Join / Read Data

jformicola 31 Mar, 2020
How do I join in additional data to be displayed in a drop-down that is fed by a read data?

Please see the belowimage. The data being displayed there is coming from a read data that is using a CONCAT statement. I'd like to display the trainer's name instead of the ID number, but the name is in another table. Can you help please? Thanks!

Join / Read Data image 1
Join / Read Data image 2
healyhatman 31 Mar, 2020
There's an "add model" button on the read data action. And the format will be

CONCAT(model.fieldname , ' | ' , model.otherfieldname , ' | ' , model.otherotherfieldname):model.alias

Take note of the space around each comma
jformicola 01 Apr, 2020
Oh nice, thanks. Thank you for the note on the comma, that explains some past difficulties. I had to setup like this for my situation. (used the relation conditions)

Join / Read Data image 3
This topic is locked and no more replies can be posted.