Restrict number of records

[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.

 

[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.

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]