Getting values from a table and concatenate them




Hi All,

I think somebody out there should be able to help me.

I have a list of contract numbers the user has to type in.

I've created a table where user can add as many rows as needed. Each row is a contract number.

Once completed, I have to concatenate all of the contract numbers, separated with commas, so that I can send them to a floating field within a text box.

It should look like this.

.....1234, 2345, 3456 and 5678 (assuming these four values were keyed in by the user in the table form)

Anybody can help me explaining how to concatenate the values and put them into the floating field?

Thanks in advance.






You can concatinate them easily but getting them into a floating field on the same form will be an issue. The floating field can only be filled when th eform is rendered and data is placed on the form. Floating fields are not interactive...so after the data load they are turned into text....they are not even fields anymore.