Re: Group and User join

2008-12-05 Thread LJ Longwing
Take a look at the active link that fires on 'SHOW MEMBERS' button in the group form. Copy that open window qualificationand use that as your join criteria for the join formsee if that works for you...:) _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: Group and User join

2008-12-05 Thread Warren Baltimore
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

Re: Group and User join

2008-12-05 Thread Howard Richter
Warren, I thought there was a way to do that already, but I am dealing with 7.x not 6.3. You might need to do a join. Howard On Fri, Dec 5, 2008 at 12:04 PM, Warren Baltimore [EMAIL PROTECTED] wrote: ** Folks, I've got a need to join the Group and user forms so that I can report off of the

Re: Group and User join

2008-12-05 Thread LJ Longwing
make this your join criteria, I thinkyou 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

Re: Group and User join

2008-12-05 Thread Warren Baltimore
: [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