Try using two pipes to concatenate the values instead of a plus sign. Axton Grams
On Fri, May 8, 2009 at 1:48 PM, Kemes, Lisa <[email protected]>wrote: > ** 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"_ > _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"
