7 Replies Latest reply on Sep 11, 2009 6:13 AM by comment_1

    Rookie question: Table primary key based on two fields

    robbbarbosa

      Title

      Rookie question: Table primary key based on two fields

      Post

      Dear friends,

       

      I'm needing to do a primary key for my table based on two fields (state and city). I've tried to set the fields unique, but doesn't work. In a first record I set "Florida / Miami"...let's ok. In a second I try "Florida / Tampa" and I received the message "Allow to duplicate.....etc". Is there a way to solve this? Thanks in advance

       

      Roberto Barbosa

      Brasil.