M
Martin
Dear experts,
how can I utilize the relatedness of the tables in the relational database
in VBA-Access?
It means concretely the task to write a small program that edits all pages
of a book, on which a certain chemical substance is mentioned. The database
is ready and contains a table listing the substances and another table
listing the pages of the book. I have created an m-n 'relation' between these
tables (using an appropriate detail-table), that means that a certain
substance can appear on several pages, and that a certain page can contain
several substances. The relatedness of the database works in the sense that I
can click next to an entry (substance) and a pop-up windows shows me all
pages, where I can find it (under the field 'look up in ..') with the correct
correspondences - but how can I grab these results bei a VBA-script?
Thank you
Martin
how can I utilize the relatedness of the tables in the relational database
in VBA-Access?
It means concretely the task to write a small program that edits all pages
of a book, on which a certain chemical substance is mentioned. The database
is ready and contains a table listing the substances and another table
listing the pages of the book. I have created an m-n 'relation' between these
tables (using an appropriate detail-table), that means that a certain
substance can appear on several pages, and that a certain page can contain
several substances. The relatedness of the database works in the sense that I
can click next to an entry (substance) and a pop-up windows shows me all
pages, where I can find it (under the field 'look up in ..') with the correct
correspondences - but how can I grab these results bei a VBA-script?
Thank you
Martin