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"