Use a SQL menu: select full_name from user_x where group_list like '%$groupID$%' of course, you'll have to have another SQL menu which lists the group names, and a link that looks up the groupID for the specified group: select group_name, group_id from group_x The above syntax assumes Oracle; you might have to tweek it a bit for other DBs
-Aaron * Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Durrant, Michael M. - ITSD Sent: Monday, July 23, 2007 3:13 PM To: [email protected] Subject: List of users in a group ** I'm trying to create a menu that lists people who are in a certain group, but Public does not have access to the User form and I don't wish to make it that way - the People form doesn't contain group information. Ideas? Thanks, Michael The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. __20060125_______________________This posting was submitted with HTML in it___ SunCom is the wireless company that's committed to doing things differently. Things we want you to know. This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by the attorney-client privilege. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
