Help with initiation idea?

[Tyinawyn]

Hi everyone,

Have designed a database that records incidents accidents and near misses. We have a number of services who will be using this database. Due to other sharing difficulties I will need to collaborate queries sent to me via email in excel format. This is fine however at this point I need to know the area and particular services the info has come from as we are analysing on a corporate scale.

Is there any way that when the database is first used that an initialisation screen could prompt for your area and services? Could this then be attached as a field within my accident/incident all tables?
I am trying to make it as user friendly as possible as little of our staff are able to work with access.
Would also be great for saving time as the only other solution I can think of is to have fields on every record, but the data will be the same - a nightmare if you are filling London incidents accidents!

Thanks

 

[Tyinawyn]

Lots of, not London lol!

 

[Tyinawyn]

Any ideas guys and gals?

 

[HiTechCoach]

Ir sounds like the sane database will be installed at multiple locations.

I assume the database has already been split. If no making updates will be very difficult.

I would create a table that is use to store all the unique information for that location.

The can by pulling into the query that is emailed to you.

The simple thing to do is to load the data into the back end before you send it to a location. You would want to create a form to edit the data.

If would be possible to have the startup routine to checks the table to see if the data has been enter. If not then open the for form that edits this information.