Database within database

[pd06498]

I'm not sure where to start with this or if this is the correct forum, but I am seeking some guidance on how to tackle this situation.

I want to create a database that enables users to use it as a running sheet, and intend to create a serial field from Auto number, an entry field where the name of the person entering the data is stored, dates, times, and a memo field to store the data. Once it is going, users will be able to record data on a particular job as it happens. This is not a problem to set up.

What I want to do is allow the user to have 2, 3 or more of these running, covering different jobs, each with their own running sheet and numbering system beginning at 1.

Is it possible to do this under the one database, or do I need to keep copying a new database from a master and have 2, 3 or more databases open.

I would also like to have the user be able to create a new running sheet from within the database as new jobs come up.

Does anyone have any ideas?

 

[Sprocket]

Just a thought but isn't this a case for a form/sub-form. The main form is the user called from the user table.

the sub-form is the job/order detail - called from the job/order table.

Then any user can have as many orders running as s/he likes.

Or have I misunderstood your requirement?

 

[pd06498]

Thanks Sprocket

That might be the answer.

Each running sheet is used to record a series of events that occur during an incident, such as an emergency situation, and there will be a number of different events each requirng their own running sheet.

I will examine your suggestion closer.