Simple way to test that values in a table are unique?
Is there any property to force repeating fields to be unique? I have multiple rows in a table and I want each instance of the "Name" field (Name[*]) to be unique.
I'm hoping there's a property I can select, so I don't have to add a script to test every row in the table to see if the value already exists. There are a lot of scripts running on this table already, so I'm afraid that more looping and testing will impact the performance as more rows are added to the table.
It is unique by default. The somExpression is what you want (not the name) and that is unique. There is an occurance number on the row (as that is the repeating subform) and thats what makes it unique. So to address the field it woudl be something like this:
No there is nothing like a check box that will only accept a unique input. You woudl have to get the value and test it against all other values in the table. You could do it on the exit event of the field and if you get a match then pop up a message box and return the cursor to that field.