Brilliant! Thanks so much! Lisa
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pargeter, Christie :CO IS Sent: Friday, September 05, 2008 1:54 PM To: [email protected] Subject: Re: Brain Stumper.... ** How about this for the Display Only form's workflow: Step 1: grab the call first, call second, call third fields Step 2: copy what is in first into tmpCallOrder Call Guide: Lookup Number Step A: if call tmpCallOrder = work, grab work and put into a tmpAnswer Step B: if call tmpCallOrder = home, grab home and put into a tmpAnswer Step C: if call tmpCallOrder = cell, grab cell and put in a tmpAnswer Copy tmpAnswer into Call First Step 3: copy what is in second into tmpCallOrder Call guide: Lookup Number Copy tmpAnswer into Call Second Step 4: copy what is in third into tmpCallOrder Call Guide: Lookup Number Copy tmpAnswer into Call Third Step 5: cleanup any fields you need to -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Kemes, Lisa Sent: Friday, September 05, 2008 10:47 AM To: [email protected] Subject: FW: Brain Stumper.... ** Form A contains these fields: Work Phone Home Phone Cell/Mobile Phone Call First Call Second Call Third So as an example of Form A would look like this: Full Name: Lisa Kemes Work Phone: 717-810-xxxx Home Phone: 717-761-xxxx Cell/Mobile Phone: 717-608-xxxx Call First: Home Phone Call Second: Cell/Mobile Phone Call Third: Work Phone I would like on another form to be able to grab all this information and put it into display only fields... On call person: Lisa Kemes Call First: 717-761-xxxx Call Second: 717-608-xxxx Call Third: 717-810-xxxx The problem is for each person, their call first, second and third field is going to be different. How would I set these fields? I need to first see what's in the Call First field on Form A, then I need to get that phone number. For example, if Call First is "Home Phone", how do I then grab the Home Phone number? Lisa Kemes AR System Developer Tyco Electronics __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
