Is there a way to create a form that utilizes a drop down and brings in info entered?
We are looking to create a form where we have 3 stages of lab testing that are done on a bin. I would like to create a form where stage 1 can enter basic data for that bin and the testing completed in stage 1, then have our 2nd lab person go to the form, select the bin number and the data from stage 1 testing would automatically populate and then have new blank fields for stage 2 testing, same thing for stage 3 testing. User would select the bin number from the drop down, information already entered from stage 1 and 2 would populate and lab tech would enter new data for stage 3 testing. Any suggestions would be greatly appreciated! thanks!!