autocompleting fields based on dependent info-Help Please
I have recently been learning filemaker pro 11 for a job I'm doing, so I'm relatively new to the software.
Please bear with me and tell me if i'm not being clear :)
I have something like 40 fields of information. A common field of information to every listing is a first and last name (eg John Smith). What I want to know if it is possible, is can I enter "John" "Smith" and have the other fields automatically populate themselves based on the name that I enter? For instance, everytime I enter John Smith into the system it automatically will list an email, phone number, assistant's name, assistant's phone number, etc?
I would like to do this without having to create an "If" script 100 lines long with If statements inside more If statements.
Have I been clear? :) Please let me know if this is possible.
thanks for any suggestions that you have.