T
takatam
Hi,
I have a table (TableRelations) which contains a list of parent-child
relationships of documents, figuratively speaking. Thereby a 'child'
is a document which is referenced to by the 'parent' document. A
parent can have several child documents (max 5), and at the same time
every parent can also be (not a must) a child document.
I would like to build a form where I can select a specific document-ID
and then two lists/tables are populated: One showing all child
documents, and one showing all parent documents of the selected
document.
Showing the list with the children is not difficult, a simple extract
from the table.
For the list of parent documents I would need to parse the part of the
table which contains the child documents, extract which documents
actually act as parent to the document in question, then remember,
list and sort the obtained list of parents.
How do I build this query? Or do I need to build multiple queries? Or
should I take a completely different approach?
Any ideas with this regard are appreciated.
Thanks for helping a newbie,
T
I have a table (TableRelations) which contains a list of parent-child
relationships of documents, figuratively speaking. Thereby a 'child'
is a document which is referenced to by the 'parent' document. A
parent can have several child documents (max 5), and at the same time
every parent can also be (not a must) a child document.
I would like to build a form where I can select a specific document-ID
and then two lists/tables are populated: One showing all child
documents, and one showing all parent documents of the selected
document.
Showing the list with the children is not difficult, a simple extract
from the table.
For the list of parent documents I would need to parse the part of the
table which contains the child documents, extract which documents
actually act as parent to the document in question, then remember,
list and sort the obtained list of parents.
How do I build this query? Or do I need to build multiple queries? Or
should I take a completely different approach?
Any ideas with this regard are appreciated.
Thanks for helping a newbie,
T