I am trying to create a table that houses when a person makes a request. I have one field where they select their name from a drop-down list. What I would also like to do is have fields update with that person's phone number and email address. I have everyone listed in a table with contact info. Is there a way to get a field in a table to perform a lookup in a different table to do this?
This is what I tried so far, but all it does is create a drop-down list and it seems to only include the first email address in the contact table. Is there another way to do this?
This is what I tried so far, but all it does is create a drop-down list and it seems to only include the first email address in the contact table. Is there another way to do this?