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___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
