For complicated reasons I had to load some data into my document in three seperately named fields. I would like to include the values from all 3 of these fields in the same listbox. Is that possible and how?
You can select a value from three different fields in a single list box. Create a list box and in the properties, instead of choosing a field name, choose <expression>. Then, in the expression dialog box, try this: ='my field1=' & MYFIELD1 & ' my field2=' & MYFIELD2 & ' my field3=' & MYFIELD3 then click OK. You will then have a list box that shows all of the combinations of the three field values that occur in the data. A single click on the values shown in the list box selects the corresponding value from each of the three fields at once. You should put a meaningful title into the listbox and, if needed, adjust the list box sort to sort on one of the fields.