R Rick Brandt Nov 2, 2009 #2 One way: Create an INTEGER field in your table and the Validation Rule is set to IN (1,2,3) Then set the Required property to True. Now you have to supply a value for the field and it can only be 1,2 or 3. Click to expand... It would also need to be uniquely indexed though.
One way: Create an INTEGER field in your table and the Validation Rule is set to IN (1,2,3) Then set the Required property to True. Now you have to supply a value for the field and it can only be 1,2 or 3. Click to expand... It would also need to be uniquely indexed though.
