Moderators I am sorry for creating a new topic, howevere I wanted help in that direction too thats the reason for this new topic.
As in this topic I am still intrested in creating a multiple user input for prompts ( More )
I created a derived table on the table containing the site name. Here is the code which I used there.
The original table consited of 3 fields name,code and area. Its linked using the code field.
select
name,
code,
(CASE
WHEN grp.name IN ('A','B') THEN 'SM'
WHEN grp.name IN ('C','D','E') THEN 'BC'
ELSE 'N/A' END) AS NM_Grp,
'ALL' AS Cmpl_grp
FROM
grpThe derived table name is grp_name.Parsing was fine.So SM relates to A,B and BC to C,D,E and ALL to all. I made teh necessary connections and made this table a class in the universe.
Now to edit the lov for name to include SM,Bc and All, I edited the lov and made a union query of name,NM-Grp and cmpl_grp. So the lov of name is now SM,BC,A,B,C,D,E,ALL.
However if I use this object in the reporter just the name field wgives A,B,C,D,E without the other things…but the lov includes them. I am confused here…did I go wrong somewhere.
Tq.
Moderators, if necessary pl append it to my this post
xen 
(BOB member since 2004-11-13)