Why not structure the data in a normalized way so that things like this are easy to do?
FormA stores the contact information FormB stores a reference to a record in FormA and also includes a PhoneNumber and Precedence With that structure you could simply walk a table to generate your data. Axton Grams On Fri, Sep 5, 2008 at 1:46 PM, Kemes, Lisa <[EMAIL PROTECTED]>wrote: > ** > > 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"
