Hi,
Would you be able to take a look at my database relationships and let me know if I've got them correct based on this info?
Step One
All the relevant and required information for a procedure is entered into the main procedure table.
Step Two
Once a review is initiated, the relevant data will be entered into the review table and the record will be checked as Under Review.
Step Three
When a procedure needs to be reviewed, the status will change and for the first time, data will change in the Review table. This table needs to be linked to the original procedure, as the field will be shown within the sub form of the Main Procedures Form. Fields from the Main Procedures table will also be included as a sub form on the review table
If while carrying out the review, a change to the procedure is required, the version control table will also be updated. A review can happen without a change to the version control table.
Step Four
Every time the version control table is updated, the Signed Off table will also need to be updated, there will be no exceptions to this.
Hopefully I've explained it ok...
If you could take a look at how I've set the relationship joins and let me know if they are right that would be great.
Thanks
Would you be able to take a look at my database relationships and let me know if I've got them correct based on this info?
Step One
All the relevant and required information for a procedure is entered into the main procedure table.
Step Two
Once a review is initiated, the relevant data will be entered into the review table and the record will be checked as Under Review.
Step Three
When a procedure needs to be reviewed, the status will change and for the first time, data will change in the Review table. This table needs to be linked to the original procedure, as the field will be shown within the sub form of the Main Procedures Form. Fields from the Main Procedures table will also be included as a sub form on the review table
If while carrying out the review, a change to the procedure is required, the version control table will also be updated. A review can happen without a change to the version control table.
Step Four
Every time the version control table is updated, the Signed Off table will also need to be updated, there will be no exceptions to this.
Hopefully I've explained it ok...
If you could take a look at how I've set the relationship joins and let me know if they are right that would be great.
Thanks
