1 Reply Latest reply on Aug 6, 2014 7:15 AM by philmodjunk

    Unique value for two field in a third table.

    ZuhairAlmutawa

      Title

      Unique value for two field in a third table.

      Post

           I need to create relationship for three tables.  That the third table will have vales from two table with no duplicate at the level of two fields.? The combination input of two filed should not allowed to be reputed. 

        • 1. Re: Unique value for two field in a third table.
          philmodjunk

               I think that you are asking for a validation field option that ensures that the combination of the values of two fields in the table is always unique. If that is what you want:

               define a text field in the same table.

               Give it this auto-enter calculation:

               YourField1 & " " & YourField2

               Select a unique values validation option on this added text field.