manix
Registered User.
- Local time
- Today, 07:48
- Joined
- Nov 29, 2006
- Messages
- 100
Hi,
I have three tables in a database simply designed to control document revisions.
1. The Document Register Table where each document has record.
2. The Revision Log Table which is directly related to the Document Register as each document could have multiple revisions- so One to Many.
3. The Change Request Table where change requests can be raised to up issue documents. This is also related to the Document Register as each document can have multiple change requests but it is also related to the revision log, as each change request will be related to a new revision of a specific document.
Now my dilemma is, that I have is that I cannot get the referential integrity to work on the document when I use the Change Request form because this is a revision log subform of the change request log, it has no direct relationship with Document Register. It will only work when used as a subform of the Document Register! It's almost like I need a fourth direct relationship?
I have attached a picture of the tables and their relationships.
How can I make this work, basically I need to be able to automatically update the revision log with DocID and the ID from the change request table.
Can anyone help?
I have three tables in a database simply designed to control document revisions.
1. The Document Register Table where each document has record.
2. The Revision Log Table which is directly related to the Document Register as each document could have multiple revisions- so One to Many.
3. The Change Request Table where change requests can be raised to up issue documents. This is also related to the Document Register as each document can have multiple change requests but it is also related to the revision log, as each change request will be related to a new revision of a specific document.
Now my dilemma is, that I have is that I cannot get the referential integrity to work on the document when I use the Change Request form because this is a revision log subform of the change request log, it has no direct relationship with Document Register. It will only work when used as a subform of the Document Register! It's almost like I need a fourth direct relationship?
I have attached a picture of the tables and their relationships.
How can I make this work, basically I need to be able to automatically update the revision log with DocID and the ID from the change request table.
Can anyone help?