2 Replies Latest reply on Mar 7, 2012 1:57 PM by star_cookie_queen

    How to select from drop-down menu connected to SQL database and then autofill?

    star_cookie_queen

      Hello,

       

      I am in the process of creating a series of forms and I need some help if working out how to do the following.

       

      I have already set up a data connection to an SQL database, and I have three fields connected: Job Number, Job Name and Customer Name.

       

      What I want to do is have it so that the Job Number is a dropdown box, so they can select the number, and then the other two fields, Job Name and Customer Name, are autofilled to the information corresponding to the Job Number.

       

      Is anyone able to help me do this please??

       

      Thank you!!