Limit Table to one record 2

[cbiker]

Can I limit a table to one record the table is used to set up a report so if there is more than one record we get the wrong results.

 

[missinglinq]

I have a table that's used to enter company contact data (company name, address, URL, fax & phone numbers). The application then uses this data as headers for the various reports. I needed to limit the table to one record, and I did this by accessing the table thru a form. The form's properties are set to:
Allow Edits Yea
Allow Additions No
Allow Deletions No
Data Entry No

Hope this helps.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[cbiker]

Thanks for the help. I was thinking to hard I guess.

 

[jsteph]

Best way--in the Table design:

Field:
name=Recid
Type=integer
Indexed=unique-no dups.
Validation rule=1
Validation Text=Only one record, please.
Give the record the value of 1.

No more can be added.
--jsteph

 

[jsteph]

...required must be Yes also...
--jsteph

 

[cbiker]

Great this is just what I was looking for Thanks