We have a database that is used at 3 different sites for taking attendance. Student come in and enter their unique student ID. We want to differentiate between students at site A, site B, and site C without asking them for their site, without having the on-site administrator enter this information, and using the same database.
How can this be achieved? Thanks