Can you do a sql menu with distinct Take Care Dale Jones 919-523-6034
Take Care Dale Jones 919-523-6034 > On Oct 4, 2017, at 4:39 PM, Brittain, Mark <[email protected]> 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 > <image001.png> > > _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"
