2 Replies Latest reply on Jun 19, 2012 12:14 PM by philmodjunk

    search by last name within a field

    JoshPoplawski

      Title

      search by last name within a field

      Post

       

      I know this is fairly straight forward but I can’t figure it out or find a tutorial online.

       

      I have a table of 400+ employees (First name, Last name, ID#, Position, etc). I have another table set up for scheduling. To enter someone into the schedule you need to enter their ID#. However my clients don’t want to have to enter in the persons ID#, they want to begin typing the persons last name in the last name field and have a drop down list that narrows down who it could be based on what’s typed in the box, and then be able to select the appropriate option provided.

       

      Fore example, I type “A” in the Last name field the drop down list would appear under the Last name field with: “Adams”, “Archer”, “Ashelton” and the user would then click “Archer” and that would enter their ID# into the scheduling box.

       

      Obviously ID# is the primary key connecting the Employee table to a large number of other tables in the staffing database.

       

      If some one could direct me toward a video tutorial or any tutorial on how to set this up I would really appreciate it. Thanks J