Currently we only use the database to store information about bookings that have actually been booked. And anything that has yet to be booked remains on paper and in a folder.
Ideally we want to move to a paperless system, so as soon as we get the booking (via email/fax/telephone) it goes onto the system (where as now we take the booking and put it in the folder and book it nearer the time).
Problem I'm having is how do I implement something like this?
Do I mix the "ToBeBooked" data with the "AlreadyBooked" data? And put some sort of marker against the "ToBeBooked" data so it doesn't show up/intefere in other queries/reports that pull information from "AlreadyBooked" data.
Or do I create a new table and accompanying forms and queries for the "ToBeBooked" data but store it in the same database and then just use a macro to move the record over once booked?
FYI we work in the public sector providing a service to health professionals.
Thank you!
Ideally we want to move to a paperless system, so as soon as we get the booking (via email/fax/telephone) it goes onto the system (where as now we take the booking and put it in the folder and book it nearer the time).
Problem I'm having is how do I implement something like this?
Do I mix the "ToBeBooked" data with the "AlreadyBooked" data? And put some sort of marker against the "ToBeBooked" data so it doesn't show up/intefere in other queries/reports that pull information from "AlreadyBooked" data.
Or do I create a new table and accompanying forms and queries for the "ToBeBooked" data but store it in the same database and then just use a macro to move the record over once booked?
FYI we work in the public sector providing a service to health professionals.
Thank you!