After checking the way-back machine; the answer is to set the menu to search the field to which it is attached.
Because menus are natively distinct, you’ll get one listing for each name, and new records are automatically added to the menu. HTH, Joel Joel Sender * [email protected] From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Thursday, October 5, 2017 12:49 AM To: [email protected] Subject: Re: Menu on same field ** Hi, Search menus are natively distinct, so there is no need to use Direct SQL. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13) * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs Find these products, and many free tools and utilities, at http://rrr.se October 4, 2017 11:40 PM, "Brittain, Mark" <[email protected] <mailto:%22Brittain,%20mark%22%20%[email protected]%3e> > wrote: ** Hi All This is one of those case where I did something years ago and can’t remember how I did it. Hoping someone can assist. Have 10 records and the First Name field contains Joe, Joe, Bob, Joe, Mike, Joe, Bob, Mike, Joe and Bill. On the same field I want have a menu that searches on the First Name field and displays Bill, Bob, Joe, Mike. If I create a new record I could use the existing names or type in a new one. If the new record was for Mary, after submit, the menu would contain Bill, Bob, Joe, Mary, Mike I just know this is simple enough to do, but it was about 10 years last time I did it. Any suggestions would be greatly appreciated. ARS 9.1 Thanks Mark Mark Brittain | Senior Systems Engineer | 315.634.9337 125 Elwood Davis Road | Syracuse NY 13212 new_spectrum _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
