Not sure if this is simple or if I need to make some custom code so I thought I would ask first.
I have a table with Date and hours... each year members add the number of total hours they worked for the year i.e. year 2014, hours 1500
I want each member to only be able to add one set of hours for a year... meaning I don't want to have the following in their record
MemID Year Hours
111 2014 1500
111 2014 1332
I was trying to use the "prevent duplicate values" in the EDIT AS settings, but that blocks everyone from using 2014 after the first person.
Is there a simple way to have it only checking the person's record not the whole SQL table?
I am guessing this is going to require some coding, but i wanted to ask to see if I could save some time through a built in function I am missing.
Thanks!!
