Is there a way to limit the number of records in a table to say 1 or 5 or 10?
S Steve Nov 28, 2005 #1 Is there a way to limit the number of records in a table to say 1 or 5 or 10?
J John Vinson Nov 28, 2005 #2 Is there a way to limit the number of records in a table to say 1 or 5 or 10? Click to expand... One sneaky way is to assign an integer field as a Primary Key, and give it a validation rule such as 0 AND <= 5 Click to expand... John W. Vinson[MVP]
Is there a way to limit the number of records in a table to say 1 or 5 or 10? Click to expand... One sneaky way is to assign an integer field as a Primary Key, and give it a validation rule such as 0 AND <= 5 Click to expand... John W. Vinson[MVP]
M mscertified Nov 28, 2005 #3 Not without preventing it yourself by checking every time you are about to update the table. Why would you want to do that? There is almost certainly a better solution. Dorian
Not without preventing it yourself by checking every time you are about to update the table. Why would you want to do that? There is almost certainly a better solution. Dorian
M mnature Nov 28, 2005 #4 For the Validation Rule of your key field (numeric, unique), put in something like this: =1 Or 2 Or 3 Or 4 Or 5
For the Validation Rule of your key field (numeric, unique), put in something like this: =1 Or 2 Or 3 Or 4 Or 5
