Hi
I'm currently making a database for a construction company. The company wants a database of snags (things that go wrong in the houses they build, boilers not working etc), which is what I've made below.
In the attached database, you'll see three tables: all snags, active snags and closed snags. Records will be saved saved in the "all snags" table by means of a form.
What I want to happen is that when the user saves a new snag, all the data is copied to the "active snags" table in a new record as well as being saved in the "all snags" table: essentially the same records exist in both tables.
Also, when the user goes back and changes the record and clicks the yes/no box to yes in the "Completed?" field, the database should automatically delete the record from the "active snags" table, but create a new record with exactly the same data in it in the "closed snags" table, so now the same record exists in the "all snags" table and the "closed snags" table.
You might ask what the purpose of this is. It is because the managers will very rarely be going back through the closed snags, 99% of the time they'll want to be looking at just the active snags. Doing the database this way means that they can be shown the table with just the active snags in, apart from when they want to see the closed ones.
I'm very new to this sort of thing, so please try to make answers as simple as possible!
Thanks in advance,
Will
(Access 2010, 64 bit)
Snag Management.zip