3 Replies Latest reply on Aug 3, 2009 5:47 PM by comment_1

    lookup function that  relates to another field.

    rllewis

      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.