using a list to enter data
Please help! I need to create a database of appointments that will include names of students (2000+) that need to be spelled correctly so as to be able to omit duplicates so that I can count the number of unique students that were seen. Unless there's an easier way to do that?
The names will be hand-written and sometimes misspelled, so I thought if the administrator could just type in part of the name, a list of names would pop up for to to select one. Kind of like a value list, but the number of students is too long to put into a value list.