sql - Access 2010 How to differentiate between users with same name -

i have access 2010 database student names. each student has unique id. want design form record student visited library on date. problem 2 or more students can have same name.

question 1: how design form enter date visited library. cannot expect person remember student name , id. id nothing indexed column in access.

question 2: how should design form? should user first search student , how add record student? or there field allow me choose student , populate id?

any ideas?

joe

make relationship between students , visits table.

then, on visits form, make combo box choose student (the source of combo query students table have additional details identify, such middle name, birth year, city, hair color or whatever want)

and put textboxes on form visit date, library , on.