I am creating a table which will contain the following information:
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.