G
GillesScouvart via AccessMonster.com
I have a list of keywords, linked to different documents (many to many
relationship). I would like to show in a form the list of keywords and the
number of documents linked to each keyword.
The trick is that:
- I only want to count the hits among selected documents (field "Sel" in
Documents table; this selection is expected to change dynamically)
- I want the query to be updateable (the user must be able to select keywords)
I've created a separate query for counting the documents, and linked it to
the Keywords table based on PK, but the result is desperately not updateable.
Has anyone an idea, without resorting to heavy temporary tables?
relationship). I would like to show in a form the list of keywords and the
number of documents linked to each keyword.
The trick is that:
- I only want to count the hits among selected documents (field "Sel" in
Documents table; this selection is expected to change dynamically)
- I want the query to be updateable (the user must be able to select keywords)
I've created a separate query for counting the documents, and linked it to
the Keywords table based on PK, but the result is desperately not updateable.
Has anyone an idea, without resorting to heavy temporary tables?