AppGini Community Forums

First time poster here, I'm looking to select a parent record with the Lookup field option, but once selected, I can only show one or two values as the field header. That's ok, but I also want other parent table data to appear beyond just the name on the sub table view.

So for instance, in my roster table, I can select the person from the parent table, but it only shows the name, not any other detail. Is this custom code? Thanks in advance!

Hi,

if I get right what you try to acheive, you can do this through the advance lookup option. You can edit the predefined SQL to match your needs.
You need to keep key (mostly the id) as first element.

Update, I figured it out, you have to modify the query in the advanced tool, specifically the part where it appends data.

So ... CONCAT_WS('', `batterStatsYTDCSV`.`first`, ' ', `batterStatsYTDCSV`.`last` , ' - ',`batterStatsYTDCSV`.`team`), '') FROM...