B
breg via AccessMonster.com
All,
I tried to solve this in December, but without success... I'm not a newbie,
but I'm not very good in db desgining as well, it's more like trail and error
...
Ok, so I'm creating a db where the history of submitted documents (which are
part of a project) can be traced. A document can be submitted more than once.
So in short, this is how it is:
1st level - General project information (displayed on tabpage1);
2nd level - Project related documents (displayed on tabpage2).
3rd level - Muliple revisions of the project related document (displayed on
tabpage3).
What I created is: tblProjects, tblDocuments and tblRevisions. On a first
subform, I managed to relate and display the applicable documents to a single
project. However, on a second subform I'm unable to relate the revisions to a
single document (which is diplayed on the first subform).
The properties look like this:
First subform, parent / child link: tblProjects(ProjectID) / tblDocuments
(DocumentsID) as 1:Many.
Second subform parent / child link: tblProjects(ProjectID) / tblRevisions
(DocumentsID) as 1:Many.
To my idea the second subform properties aree not correct as I think the
parent / child should be: tblDocuments (DocumentsID) / tblRevisions
(DocumentsID).
Can anyone help me out? Or does anyone have a good example of how this is
normally done?
If i'm unclear please let me know, and I'll try to clarify it more.
Regards,
Arjan
I tried to solve this in December, but without success... I'm not a newbie,
but I'm not very good in db desgining as well, it's more like trail and error
...
Ok, so I'm creating a db where the history of submitted documents (which are
part of a project) can be traced. A document can be submitted more than once.
So in short, this is how it is:
1st level - General project information (displayed on tabpage1);
2nd level - Project related documents (displayed on tabpage2).
3rd level - Muliple revisions of the project related document (displayed on
tabpage3).
What I created is: tblProjects, tblDocuments and tblRevisions. On a first
subform, I managed to relate and display the applicable documents to a single
project. However, on a second subform I'm unable to relate the revisions to a
single document (which is diplayed on the first subform).
The properties look like this:
First subform, parent / child link: tblProjects(ProjectID) / tblDocuments
(DocumentsID) as 1:Many.
Second subform parent / child link: tblProjects(ProjectID) / tblRevisions
(DocumentsID) as 1:Many.
To my idea the second subform properties aree not correct as I think the
parent / child should be: tblDocuments (DocumentsID) / tblRevisions
(DocumentsID).
Can anyone help me out? Or does anyone have a good example of how this is
normally done?
If i'm unclear please let me know, and I'll try to clarify it more.
Regards,
Arjan