Oh... It sounds like you need 3 SQLs unioned together then
Try SELECT field1 FROM tablex WHERE fieldontablex = '$fieldonopenform$' UNION SELECT field2 FROM tablex WHERE fieldontablex = '$fieldonopenform$' UNION SELECT field3 FROM tablex WHERE fieldontablex = '$fieldonopenform$' Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Friday, May 08, 2009 2:46 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field Thanks, the vertical bars worked. But now I'm just getting one field to select from "717-555-2408 717-555-3254" I want the customer to choose 717-555-2408 OR 717-555-3254... Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Friday, May 08, 2009 3:21 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field What Database are you using? For Oracle you use 2 vertical bars SELECT DISTINCT(field1 || ' ' || field2 || ' ' || field3) FROM tablex WHERE fieldontablex = '$fieldonopenform$' Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Friday, May 08, 2009 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field I get an "invalid number" when I plug this into the menu and try the select field on the form. Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Sent: Friday, May 08, 2009 1:51 PM To: arslist@ARSLIST.ORG Subject: Re: 3 Fields into one Selection Field Lisa, You can combine multiple fields into 1 menu using a SQL menu type. SELECT DISTINCT(field1 + ' ' + field2 + ' ' + field3) FROM tablex WHERE fieldontablex = '$fieldonopenform$' Jason Bess Remedy Engineer Camp Victory, Iraq ________________________________ From: "Kemes, Lisa" <lisa.ke...@tycoelectronics.com> To: arslist@ARSLIST.ORG Sent: Friday, May 8, 2009 7:12:58 PM Subject: 3 Fields into one Selection Field I'm creating an on call system and I have three fields, Work Phone, Home Phone and Cell Phone. I also have three other fields called Call First, Call Second, Call Third. I'd like to have the Numbers in the first three fields be a selection on a drop down menu for each of the other three fields. Is there a way to do this? (I don't think so). I have it set up the they can choose from a set of responses like "Work" "Home" and "Cell" but I would rather have the actual phone numbers for them to choose from..... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
