Sean, you can make use of a SQL-Menu with the following statement SELECT login_name FROM user_x WHERE group_list LIKE (SELECT group_id FROM group_x WHERE group_name = '$536870925$')||';%' OR group_list LIKE '%; '||(SELECT group_id FROM group_x WHERE group_name = '$536870925$')||';%' OR group_list LIKE '%;'||(SELECT group_id FROM group_x WHERE group_name = '$536870925$')||';%' HTH Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Sean Harrodine Gesendet: Montag, 31. August 2009 12:09 An: arslist@ARSLIST.ORG Betreff: Re: Menu problem....Group List id issue ? ** Hi Frank, To your knowledge, is there no way around it other than storing the id and having to use that ? Sean ________________________________ From: Frank Caruso <caruso.fr...@gmail.com> To: arslist@ARSLIST.ORG Sent: Monday, 31 August, 2009 10:48:48 Subject: Re: Menu problem....Group List id issue ? Store the GROUPID value (number) in a temp field when the user selects the assigned group. Then use the temp value in your menu. On Mon, Aug 31, 2009 at 12:43 PM, Sean Harrodine<sean_rem...@yahoo.co.uk> wrote: > ** > Hi everyone, > > Can anyone help me with the following menu / query issue please on a bespoke > app..... > > > I have a field name on a form called AssignedToGroup (id = 536870925). An > example of its contents would be "TECH_PLAN" > > On the same form i have a field called Assignee (id = 536870926) > > The group TECH_PLAN exists in the group form and there are 3 users in the > User form that have TECH_PLAN in their Group List > > > I have created and attached a menu to the Assignee field, with the following > query against the User form........ > > 'Group List' LIKE ( "%" + ($536870925$ + "%" )) > > .....in the hope that the menu will display a list of the users with > TECH_PLAN in their group list but it doesn't > > > I suspect this is something to do with that the User form actually stores > the ID for the Group in the User Form. > > Is there anyway of being able to present a menu based on using the actual > Group Name, rather than the group ID ? > > > TIA > > Sean > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"