nuBuilder Forum

Posted: **Wed Jun 06, 2018 11:21 am**

Hey,

I need the following in a subform:

table1
  table1_id
  tb1_table2_id
table2
  table2_id
  field1
  field2

Now, in my table1 edit form I need to place a lookup into table2 that displays BOTH field1 and field2 in the description field.
Is that possible?

Maybe the best way is to create the combined field as a virtual field in MySql?

Posted: **Wed Jun 06, 2018 11:37 am**

Hi,

I'm not sure I understand your question.

By using CONCAT you can concatenate two or more columns together.

contact_lookup.png

Posted: **Wed Jun 06, 2018 3:59 pm**

Cool, that will probably fix it. So did a virtual field. That probably saves me some more head scratching too.

Posted: **Mon Jun 11, 2018 2:30 am**

nuBuilder Forum

Displaying two fields in a lookup

Displaying two fields in a lookup

Re: Displaying two fields in a lookup

Re: Displaying two fields in a lookup

Re: Displaying two fields in a lookup