Limit Number of Records in a table

[Guest]

Is there a way to limit the number of records in a table to say 1 or 5 or 10?

 

[John Vinson]

Is there a way to limit the number of records in a table to say 1 or 5 or 10?

One sneaky way is to assign an integer field as a Primary Key, and
give it a validation rule such as

0 AND <= 5

John W. Vinson[MVP]

 

[Guest]

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

 

[Guest]

For the Validation Rule of your key field (numeric, unique), put in something
like this:
=1 Or 2 Or 3 Or 4 Or 5