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.

 

[Joseph Meehan]

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.

Can you restrict direct access to the table? Using a form you can
disallow additions and deletions in the form properties, only allowing edits
and manually add five blank records.

 

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

 

[Joseph Meehan]

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]

I like that one.