lookup function that relates to another field.
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.