Using Forms 10.2.1.205 and 10.2.1.246 I have a multi-line field that has a lookup Fill rule associated with it (no when). It lets me create the rule, but when I go to select the multi-line field I am displayed with options like I am with a single line field. Is this supposed to work?
Question
Question
Replies
A multi-line field is still treated the same as a single line as far as data lookups are concerned, i.e., they are both still single-value fields receiving multiple values from the lookup. Seems counterintuitive at first, but this behavior does make sense because even with multiple lines there is still only one string/value.
Two ways around this would be to store all the values in a hidden table/collection and try using a formula to put them all into the multi-line (I believe this would separate them by commas), or by creating a stored procedure that concatenates the values with line breaks into a single result string that will go into the field.
Jason,
So what I'm saying is that it is not behaving the same as a single field. With a single line field I can have just a fill lookup rule to allow users to type something in the field or select from a list that is populated from the lookup. When I do the same thing with a multi-line field it does not give the options from the lookup rule.
Oh right, yea it won't do that as far as I know. My guess is that it has something to do with one being an input element and the other being a textarea element.
Maybe a feature request? Seems like it should be possible and it would be beneficial.