Hello all,

I have a form in my VM at the moment which requires a submitter to select a printer from the list of available devices before booking the showroom for the day. Once the printer is selected there is a list of components that are currently on that printer displayed below in a table.

From this form I'm feeding the data back to a SQL table in ExternalTables called 'CalendarBookings' via the Workflow tool.

I am running aground, however, when it comes to concatenating the values in the printer list drop down menu and the table of components. The field I have for this is a lengthy (500) varchar one and it has taken data of this nature before via direct injection and the workflow tool doesn't appear to be dropping me any errors regarding input for this field. The rest of the row is populating as expected when the form is submitted.

Is there an issue concatenating values from a drop-down menu & a table? Or is it more that concatenation in to one column in SQL isn't possible in the Insert Data function?

Or, magic option 3, I'm doing something horrendously wrong...