Filter user by year( help)
I am creating a DB with the following 3 tables,
( u_pk number auto-enter serial,
u_name Text )
( c_pk number auto-enter serial
c_name Text )
( r_pk auto enter serial
Get_Year (year (r_date_regist))
where each user can only do one course per year
example: (2009 - course A, 2010 - B and 2011 - C)
I tried to add a combined text field in the Registration table
User_Y (where U_ser &" "& Get_Year) must be unique
but there is something wrong, is allowing me to have a user two times a year.
i dont want to have one user more than 1 time by year.
Can someone please help me? where i am doing wrong.