Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
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?
Thank you!
Well, not really. I think it'll be easier to try and sort out to get the data needed for one listbox into one field.. or use several listboxes.
Do you know how I would concatenate those tables? I have 3 separate tables each with its own field that I'd like to concatenate. Like:
Table 1:
load field1
FROM...
Table 2:
load field2
FROM...
Table 3:
load field3
FROM...
Hi Brandon,
Could you be more specific in your problem? There are several ways to concatenate tables. Not sure what you really want. Hi Johannes!
Regards,
Xue Bin
you use like
tab1:
load field1 as com_field,
'A' as type
from filepath;
tab2:
load field2 as com_field,
'B' as type
from filepath;
tab3:
load field3 as com_field,
'C' as type
from filepath;
com_field have all your fields using type you can identify which field
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.