E Elwin Jan 23, 2004 #2 I did this by setting the validation rule property of my primary key field to =1. By definition, my primary key MUST be unique. By design, it MUST be equal to one. Voila! Only one record possible in the table. Good luck.
I did this by setting the validation rule property of my primary key field to =1. By definition, my primary key MUST be unique. By design, it MUST be equal to one. Voila! Only one record possible in the table. Good luck.
J John Vinson Jan 23, 2004 #3 How do you limit the table so it could hold only 1 or 2 records? Click to expand... One good way is to have an integer Primary Key, with a validation rule of =1 to limit it to one record; or IN (1, 2) to limit it to two.
How do you limit the table so it could hold only 1 or 2 records? Click to expand... One good way is to have an integer Primary Key, with a validation rule of =1 to limit it to one record; or IN (1, 2) to limit it to two.
