creating single entry tables (1 Viewer)

[bink_m]

Hi,

I am building a database which may be used in several projects. Each project uses its own copy of the database, so they start with an empty database. What I want is for the user to be able to enter and maintain the basic data for the project (reference number etc.) in what's basically a single record. My thought was to create a table, but this table should have a maximum of one record. Any ideas on how to do this?

Greetings,
Martijn

 

[llkhoutx]

Create a index field in your one record table; then when referencing that table, always use that index. That way it doesn't matter what gets into to the table, you'll always be accessing with your index value.

 

[neileg]

Limit by form

Only allow the user to see the table in a form. Then set the form properties to edit only. This will prevent records being added or deleted.