How do you get one form to populate another form?

I am very new to Zoho and deluge, but I have worked quite a bit with Access. I cannot seem to figure out how to do something that was very easy for me to do in Access.

I am trying to create a Campus Leave log for students in a dormitory. I have a form that lists the names all the residents and another form for them to fill out when they leave. That part works well. I also have a View that shows all the students who are currently checked out. The problem is I want the student to be able to select their name from a picklist, have that call up a new form specific to them, with a button that, when clicked, will change their status to "In" and record the time they checked in. I can get everything to work except for the part of tying the picklist, populated with names from the Students form to query the Check-Out form for that student's name and the entry that has them checked out. I know it should be easy to do, but I can't figure out the syntax to use. Can you help me?

Thank you.