Okay, I have a big one. Sorry, and thank you in advance.
I have a paper/word type form which will be entered onto access by one person.
While building the forms for the database, I had the sudden realisation we would have problems when a new version of the form came out which removed/added/split up questions.
So, I want to be able to create a new version of the form in access in as simple a way for the user as possible, where they can:
Automatically pull through selected questions from the most recent version - most of the questions will be consistent throughout so having to select them all would be annoying
Include questions from older versions - I'm not sure, but this may occur an would be easier if this is an option
Add new questions - would be appropriate in the cases for added/split up questions
Change "risk" of the question - each question has a "risk" of high, medium or low, occasionally a question may be re-categorised so this would need to be included somehow.
We may occasionally need to submit older versions to access (where the "assessor" has submitted late/not used the most recent) so we would need to keep the old versions in the database for this.
The only way I can think of doing this is by creating a new table and adding it to the relationship etc. each time... I'm not even sure if that's possible, let alone if it would work
Your help is much appreciated.