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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
