On User input BUG with Collection Lookup?
I have had a problem in my application with On User input as follows (simplified code that replicates the problem is below and here is
Link to sample app ):
Form Test1 is designed to look up data from the database for form Test2 based on the user choice in Test1 field T1_lookup. I then want to populate some Test1 fields with default data from the Test2 database for the user to edit. Everything works fine the first time the user chooses a value from the list in T1_lookup. The problem is that if the user goes back and selects a different value in T1_lookup then all that happens is that the spinning wheel cursor shows and nothing else happens. The same problem happens even after a Submit action. Sometimes I get an error box that pops up with "12152: Unknown". Then when I hit ok in the error box I am returned to my home page with the apps listed.
Code:
form Test1
{
T1_lookup
(
displayname = "Lookup 1"
type = picklist
values = Test2.T2_single_line
sortorder = ascending
on user input
{
collection = Test2 [T2_single_line == input.T1_lookup];
set T1_single_line = collection.T2_single_line;
set T1_multi_line = collection.T2_multi_line;
}
)
T1_single_line
(
displayname = "Single Line 1"
type = text
)
T1_multi_line
(
displayname = "Multi Line 1"
type = textarea
)
}
form Test2
{
T2_single_line
(
displayname = "Single Line 1"
type = text
)
T2_multi_line
(
displayname = "Multi Line 1"
type = textarea
)
}
[/img]