4 Replies Latest reply on Feb 14, 2017 4:44 AM by weedonpaul

    unique values

    weedonpaul

      Hi

       

      I have a table in my database for accounts stuff and each record has type, month and year whilst I will have many  who share one or even two of these no record should ever share all three.

       

      I have tried to create a text field with auto enter calculation month&type&year and must be unique, but it doesn't work because it fills itself out before I have selected the other options.

       

      is there away to do this differently?

       

      Paul