13 Replies Latest reply on Jun 8, 2011 12:31 PM by Seregil

    autocompleting fields based on dependent info-Help Please



      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.