I would like to use the multiple item option on a lookup field. The problem is that the control only allows for single line of text to write the data to. Ideally I would simply capture the ID of the values selected, but it returns the ID and the text. The text side limits it down to text. I tried a calculated value, but it will only return the ID of the first item selected. If a person chooses too many items I quickly run out of space with the limit at 255 characters. Any ideas?