Trying to get info from one table into another, based off the selection made from a drop down box
I am pretty new to FMPro 9 and databases in general, so please forgive any basic questions that I might ask.
I have a table in my database that stores employee information, such as their name, phone #, fax #, email, etc. I have also created a value list that contains the names of these employees. What I am trying to do in another table is select the employee's name from value list in a drop down box, and have other fields in this same table automatically populatewith info such as their phone # and email.
I believe I am trying to do a lookup and have selected in the auto-enter options of the fields I want auto-populated to have them auto-enter based on the looked-up value from the fields in the employee's table that stores the phone #, email, and so on. However, it does not seem to be working. I think I am probably just not doing this correctly, and would appreciate any help you could give me.
Thank you very much for your time.