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!
Lookup Field - Other Parent Record Data
Re: Lookup Field - Other Parent Record Data
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.
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.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Lookup Field - Other Parent Record Data
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...
So ... CONCAT_WS('', `batterStatsYTDCSV`.`first`, ' ', `batterStatsYTDCSV`.`last` , ' - ',`batterStatsYTDCSV`.`team`), '') FROM...