Desperately needing help. I’m creating a database to hold info on magazines.
Tables – Magazine, Keywords, Authors
Relationships – Magazine – keywords (1-to-many), Magazine – Author (1-to-many)
I have created a filter form which allow users to search by Author (cbobox), Subject, & Keyword (both multi-select listbox).
I used the wizard to create the search button whereby I use the default docmd.openform , , , stlinkcriteria. I expanded on
the stlinkcriteria in VB to include author, subject, & keyword criterions into one search criteria string. When the search
button is clicked, a continuous form opens to display all the magazines that meets the search criteria. The form shows the
magazine details without the author and keyword fields.
I’ve got it set up so that if there is nothing selected, the continuous form displays all the records of all the
magazines BUT the problem is that it displays duplicate records (one record for each associated keywork and author). If I
remove the keyword and author fields from the underlying query, thus removing duplicates, the search criteria doesn’t
work because these fields are then not present. If I leave these fields in, the search criteria works but displays duplicate
How can I get the form to display only one instance of the magazine record (unique magazineID)?
I suppose it would be similar to something like a library catalogue system where, based on the entered search criteria, the
system would then display a list of each individual book although one book might be associated with multiple criterions.
Or, is it possible to write code in VB to runSQL based on the search criteria, somehow retrieve the MagazineID
(arrayMagazineID as array)that meets the criterions, and then use the openform command to open the form and display magazine
details of all the magazines where the forms magazineID = arrayMagazineID? If this is a possible solution, could anybody
give me pointers on the code I might use here?
Any advise would be appreciated.
Thx in advance,