AnsweredAssumed Answered

autocompleting fields based on dependent info-Help Please

Question asked by Seregil on Jun 6, 2011
Latest reply on Jun 8, 2011 by Seregil


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.