Gotcha! I'll give it a shot..... Warren
On Fri, Dec 5, 2008 at 1:50 PM, LJ Longwing <[EMAIL PROTECTED]> wrote: > ** I was talking about the Open Window action...it uses a qual of > > ( 'Group List' LIKE ( $Group Number$ + ";%" )) OR ( 'Group List' LIKE (( > "%;" + $Group Number$) + ";%" )) OR ( 'Computed Grp List' LIKE ( $Group > Number$ + ";%" )) OR ( 'Computed Grp List' LIKE (( "%;" + $Group Number$) > + ";%" )) > > if you make this your join criteria, I think....you should get the same > results... > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Warren Baltimore > *Sent:* Friday, December 05, 2008 10:27 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Group and User join > > ** Good thought, I actually had tried that. It set's a display only char. > field on the Group form with the group ID, and then runs the query to pull > back members. The only way for me to do that would be to create a new field > on the Group form, and I really don't want to do that! I may just have to > tell the folks who want it no. > > > On Fri, Dec 5, 2008 at 12:17 PM, LJ Longwing <[EMAIL PROTECTED]>wrote: > >> ** Take a look at the active link that fires on 'SHOW MEMBERS' button in >> the group form. Copy that open window qualification....and use that as your >> join criteria for the join form....see if that works for you...:) >> >> ------------------------------ >> *From:* Action Request System discussion list(ARSList) [mailto: >> [EMAIL PROTECTED] *On Behalf Of *Warren Baltimore >> *Sent:* Friday, December 05, 2008 10:05 AM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Group and User join >> >> ** >> Folks, I've got a need to join the Group and user forms so that I can >> report off of the group form and show the members of each group. >> >> I can't figure out how to do it! Something in the back of my head keeps >> saying I'm approaching it wrong, but I try not to listen to the voices in my >> head! >> >> ARsystem 6.3 >> ITSM 5.5 >> Oracle >> >> Any advice would be most appreciated! >> >> Warren >> >> -- >> Warren R. Baltimore II >> Remedy Developer >> 410-533-5367 >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ > > > > > -- > Warren R. Baltimore II > Remedy Developer > 410-533-5367 > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > -- Warren R. Baltimore II Remedy Developer 410-533-5367 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"