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!

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!


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
CONCAT(model.fieldname , ' | ' , model.otherfieldname , ' | ' , model.otherotherfieldname):model.alias
Take note of the space around each comma
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)

This topic is locked and no more replies can be posted.