Hi All,
I have a student database where all details of students are entered directly
onto a main form, there are a number of subforms on this that record each
students activities. One of these is an absence form that is based on a
small table as follows;
Absence No - Autonumber Primary Key
Student ID - linked to main student table
Date
Authorised
Reasons
I need to make sure that the date field cannot be repeated in this subform
for this student yet allow other students to also be absent on this date on
their form, but I'm not sure how to do this. I know that I can prevent this
when creating the table, but if student A is absent on say 9th June, then it
wouldn't allow any other student to be absent on that date. Hope I've
explained this properly, would appreciate any help you may be able to give.
I think that I'm probably have to go into the coding area for this, but I
only have very limited experience of using this.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200706/1