Search on Two Columns with Reference Field Variables

[ctsmith]

I have a custom table that is called in two reference field variables.   One of the variables need to search on column A from the table, and the other on column B.   I've seen some discussion on this, but none of them seem to have a solid solution that isn't too invasive to the table.   Since you can only set one display value to true, I can't get this to work. Any thoughts?

Thanks,

Chris

[ctsmith]

Okay, this is working how it should.   But, the problem is, when I search and choose the one I want as the entry, nothing happens.   It's blank.  

So, when I select one of these, nothing happens.   The field remains blank.   The only way I got this to work previously was when I set one of the columns on the table to display to true.   But, the problem remains, I need to select from one column on one of the variables and another column on the second variable, from the same table.

[Abhinay Erra]

Chris,

  The attributes you have is just used to search based on those fields too. But the display value will still be only one for all the reference fields. Because you can only have one display value per table.

[ctsmith]

Ahh, well, crud, I was afraid of that.   Any ideas on a workaround...   I guess the question still remains... How do you make more than one field visible on a table.   Override?  

[Abhinay Erra]

As far as I know. There is no way. One thing you could do is create a new field and calculate the value based on this reference field.

[ctsmith]

Hmmm... I don't know if calculate would work.   It wouldn't be a combination of the two fields.   One variable A, you'd want to select field Y from the table.   On variable B, you'd want to select field Z from the table.

Thanks,

Chris