Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there anyway I can use an expression or something to put the values of two different fields in the same list box?
=field1 & field2
Sorry, forgot the caveat of from two different tables.
ok, could you precise me if you need to do that in the script or directly in the list? (In the list, it's working)
Create a list box and in the properties, instead of choosing a field name, choose <expression>. Then, in the expression dialog box, try this: =FIELD1 & ' - ' & FIELD2 then click OK. You will then have a list box that shows all of the combinations of the two field values that occur in the data separated by a hyphen (you can format that any way you like). A single click on the values shown in the list box selects the corresponding value from each of the two fields at once.