Personally I would use an SQL type menu Select DISTINCT ... Fred
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Wednesday, October 04, 2017 4:39 PM To: [email protected] Subject: Menu on same field ** 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
