One record in DB

  • Thread starter Thread starter Jorge
  • Start date Start date
J

Jorge

Hello

I have a DB that I would like only one record in, no more.
This DB/Table will function as just a table with prices.

When an individual selects what transaction it is just going lookup into
this DB and pull information.
I don't want someone inadvertently stumbling into this table and adding
additional prices etc.

Thanx in advance.
George
 
Jorge said:
Hello

I have a DB that I would like only one record in, no more.
This DB/Table will function as just a table with prices.

When an individual selects what transaction it is just going lookup into
this DB and pull information.
I don't want someone inadvertently stumbling into this table and adding
additional prices etc.
Click to expand...

Use a numeric Primary Key field with a validation rule of =1 and have your one
row use the value 1 in that field. Any attempt to add more records with a value
of 1 will be rejected because the PK cannot have duplicates and any attempt to
use a different value will violate the validation rule.
 
Back
Top