HI All, I want to do a table search based on the groups a user is assigned but can't get it to work.
First I have a form called Assignees where each person is listed with one record per group assigned. On a display only form I have a table that lists the results from the Assignees form where 'User' = $USER$ Then I run a Active Link Guide that finds the users records in the Assignees form an populates the result into a character field called 'Groups' like this ;Group One;Group Two;Group Three; Now I want to search my HelpDesk form were records are assigned to those groups. I have tried 'Assigned Group' LIKE "% + $Groups$ + "%" Any ideas would be greatly appreciated. Mark ____________________________________________ Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com<mailto:mbritt...@navisite.com> (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"