limit number of records in a table

[microtoolmaker]

Is there any way to limit the number of records in a table?

 

[famousb]

yeah, don't add anymore. sorry, had to say it, one of those days.<br>
<br>
actually are you trying to limit others from appending records, or are you just using it as a preventive measure to yourself? what are you actually trying to accomplish by locking the table from adding records? <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[microtoolmaker]

I need to use this table as a &quot;template&quot; to hold 25 records with 2 fields that never change (and a dozen fields that do). This is to &quot;draw&quot; control limits on an SPC graph. And yes, I'm afraid that someone (probably me) will go too far and enter another record.

 

[JimHorton]

Number the key's 1-25 Use a validation rule K ey &lt;= 25<br>
--Jim