AnsweredAssumed Answered

lookup function that  relates to another field.

Question asked by rllewis on Aug 3, 2009
Latest reply on Aug 3, 2009 by comment_1

Title

lookup function that  relates to another field.

Post

I have a table with two kinds of data in each form: phone numbers and their cities.  In a different form, when I select the phone number from a drop down menu, I want another field which fills i the corresponding city.  How do I do this?  I seem to be able to do it if I add one phone number to the form, but when I add a second phone number in a second field, I need that one to have a corresponding city too.

Outcomes