Populating lists dynamically
Posted on 2001-06-07
I have two list items, both pop-lists. Item A and B.
I populate item A based on a query in WHEN-NEW-FORM-INSTANCE
I want to populate item B based on the value selected in item A using a query.
What I did was put the following code in the WHEN-LIST-CHANGED trigger of item A :-
groupid_B:= Find_Group( rg_B);
IF NOT Id_Null(groupid_B) THEN
groupid_B:=create_group_from_query(rg_B,'select field2,field2 from Table where field1='''||:BLK_NAME.A||'''');
/* Table has 2 fields, field1 and field2 */
However, in doing so I get the following error :-
FRM-41337 : Cannot populate list from record group
Thanks a ton,