AnsweredAssumed Answered

Filter user by year( help)

Question asked by HelderSantos on Jan 20, 2012
Latest reply on Jan 21, 2012 by HelderSantos

Title

Filter user by year( help)

Post

I am creating a DB with the following 3 tables,
  tb_user

(
u_pk number auto-enter serial,

  u_name  Text )

tb_course
(
c_pk number auto-enter serial

  c_name Text
)

tb_Registration
(
r_pk auto enter serial
  _fk_course,

  _fk_user
,
  r_date_regist,
  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.

Outcomes