Displaying two fields in a lookup

[agnar]

Hey,

I need the following in a subform:

Code: Select all

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?

[toms]

Hi,

I'm not sure I understand your question.

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

contact_lookup.png

[agnar]

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

[admin]

.