Hello Access experts, please help me on this one:
I am creating a Access database for tracking teachers' monthly works. Each teacher allows enter multiple schools for each month, but only one time for each school. For example: teacher selected month for June (drop down list field), and selected school A (drop down list), then filled in data entry fields, and saved it. Later on, this teacher selects month for June, then selects School A again. This teacher should get a message , and let her know that the data for this school this month has already exist, and cannot do it.
For the code, first, create this message, and then don't create a duplicated record on the table.
Thank you,
Cindy