Hi all,
I have a form that has several repeating sections.
The first repeating section is a client detail section. The other sections all contain a dropdown box that looks up values in the forms data source to populate it's values.
I want to be able to concatenate the clients first name and surname when populating this drop-down list if possible. It appears you can't concatenate the fields directly into the Drop-down box, so I thought you may be able to concatenate the fields into a text and then read that field into the drop-down box but that doesn't appear to work.
Any thoughts, or even better, solutions, would be much appreciated!
Thanks