I forget where it is in the manuals but you can reference fields on the form as part of the qualification of a menu. You do it by using the Field ID in $s in the Menu Qualification.
i.e. Form A has 2 fields (Class1 and Class2). Form B holds menu data for the fields in Form A (in Class1Menu and Class2Menu fields). The Class2 field menu data is dependent on the data in Class1. The menu qualification for the menu on Class2 is: ( 'Status' = "Active") AND ( 'Class1Menu' = $536870996$) Where 536870996 is the field id of the Class1 field on Form A Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Friday, May 08, 2009 11:13 AM To: arslist@ARSLIST.ORG 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"