Constants Table? Limit number of records in a table?

[Guest]

I would like to have a table that includes the general assumptions for the
database I am creating, but want to limit the number of records to 1. I want
to use this information to store values that will be used for label captions
on various forms and reports, as well as a company logo. This way I can
enter this information into this table and have a function to update the
forms based on it to make the database easy to customize for different
customers/sites. Is this a standard table type or is there a way to limit
the number of records on a table?

Thanks.

 

[Dirk Goldgar]

I would like to have a table that includes the general assumptions
for the database I am creating, but want to limit the number of
records to 1. I want to use this information to store values that
will be used for label captions on various forms and reports, as well
as a company logo. This way I can enter this information into this
table and have a function to update the forms based on it to make the
database easy to customize for different customers/sites. Is this a
standard table type or is there a way to limit the number of records
on a table?

I do this by giving the table a numeric primary key field, setting that
field's Default Value to 0, and setting a Validation Rule on that field
that says the field's value must be 0. Thus, only one record can be
stored in the table -- the one with key value 0 -- and the first record
added to to that table will get that value automatically.