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:[email protected]] On Behalf Of Jason Sent: Friday, May 08, 2009 1:51 PM To: [email protected] 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" <[email protected]> To: [email protected] 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 [email protected] _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
