AnsweredAssumed Answered

Auto fill

Question asked by RobertRichmond on Sep 12, 2013
Latest reply on Sep 13, 2013 by philmodjunk


Auto fill


     Hello all,

     I am creating a table which will contain the following information:

     Unique ID
     Staff ID
     Staff Name
     Year Level

     I have created a layout in list view which I want to display the Staff ID, Staff Name and Year Level. The information for the year level is coming from a value list. The information for the Staff Name displays a value list which comes from the Staff table.

     My question is, how do I get the Staff ID field to be automatically filled in when they select the Staff Name. The Staff ID field is simply another value which is in the Staff Table and is associated with each staff member name.