Set up table to contain only one record?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

How do you set up a table that will allow one record to be entered but
no more. Staff need to be able to change that one record, but not add
any more.
 
Not sure if you can set the TABLE that way, but you can certainly filter the
FORM they use to modify the entry. You can also make sure the FORM is set
to not allow additions.
 
Add a long integer field, make it the primary key, and enter a number into
that field. Any number will do, but for illustration let's say we choose the
number 1. Now add a validation rule to that field: =1.
 
Back
Top