I want to search my all the records in my Crew_DB for a name that I input.  Then I want to input the data from a field in that record into the existing form.  Can this be done?  Example.

crew  =  Crew_DB  [(((((((((Crew_Member_1 == input.Employee1 || Crew_Member_2 == input.Employee1) || Crew_Member_3 == input.Employee1) || Crew_Member_4 == input.Employee1) || Crew_Member_5 == input.Employee1) || Crew_Member_6 == input.Employee1) || Crew_Member_7 == input.Employee1) || Crew_Member_8 == input.Employee1) || Crew_Member_9 == input.Employee1) || Crew_Member_10 == input.Employee1)];

input.Crew_Number_Assigned = crew.Crew_Number_New;