I need to create a form that teachers will use to submit student assessments based on a 1,2,3,4 scale. Ideally the form should have those options in a pull-down list or a set of radio buttons. Obviously the record should update based on the selection made. But ALSO, if the teacher returns to that student's record, the intial selection state of the list/menu object or radio button set should reflect the last update (i.e. the content of the field in the database)
Any suggestions??????