Hi, Search menus are natively distinct, so there is no need to use Direct SQL.
Best Regards - Misi, RRR AB, http://www.rrr.se (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 (http://rrr.se) October 4, 2017 11:40 PM, "Brittain, Mark" 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 _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
