Restrict number of records

T

Tausif

Hi All Gurus,

Is there any way to restrict number of records in a table. The number of
records in a table should always be 5. Please guide. Thankx.

Tausif.
 
J

John Vinson

Hi All Gurus,

Is there any way to restrict number of records in a table. The number of
records in a table should always be 5. Please guide. Thankx.

Tausif.
Click to expand...

One sneaky way is to have an integer Primary Key field, with a
validation rule

IN (1, 2, 3, 4, 5)


John W. Vinson[MVP]
 
Top