2 Replies Latest reply on Apr 13, 2016 4:41 PM by peter.martin@sinclairdesign.com.au

    Unique index on join table

    peter.martin@sinclairdesign.com.au

      I wish to include a test to make sure there are no duplicated records on a join table.

       

      I created a field - Test Unique - within the join table as a text field: Join1ID & "/" & Join2ID.

       

      But how do I attach a Unique value validation to this calculated field?

       

      Peter