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

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.

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.