2 Replies Latest reply on Jan 21, 2012 12:10 AM by HelderSantos

    Filter user by year( help)

    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.