Re: Query of three fields simultaneously

Since a book cannot be more than one type, you only need 1 combo to search
that type. Storing multiple values in a single field (regardless of whether
or not it is possible to do so) is poor database design and a violation of
database normalization rules.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"acores" <acores@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8CD78A01-FCA7-4D5D-B947-DED78B7734A4@xxxxxxxxxxxxxxxx
Hello. Can anyone help with this problem, please?

I am building a library database and I created the table «tbl_keywords».
This table has only one field named «Keywords» and I inserted some records
on
this table such as «Fictional», «Romance» and «Technical», for example.

I inserted three combo boxes in the book form «frm_book» to allow the user
to choose the keywords associated to each book. The user can choose up to
three keywords of the table «tbl_keywords» for each book (one on each
combo
box). Each keyword chosen is saved on the books record, as «kw1», «kw2»
and
«kw3».

Everything is working fine, until this: I want to create a query that
allows
the user to see all the books of one certain type, I mean, keyword.
Imagine
that you need to see all the «Romance» books, for example. The problem is
that the query must search the keyword «Romance» in the three fields
«kw1»,
«kw2» and «kw3» of the table «tbl_books», because the user could have
chosen
«Romance» in one of the three combo boxes.

I hope I made myself clear, but ask me if you have any question, please.

Thanks in advance.

Best regards,

Acores


.

Relevant Pages

  • Re: [PHP] Mysql strategy
    ... > If I have to perform 30 LIKE searches for different keywords in a ... > 2) To select the varchar field from all the rows, ... If you are worried about the speed of this query I'd suggest rethinking ... your database structure. ...
    (php.general)
  • Re: AJAX, XML and Caching(?)
    ... or not the database was changed in the meantime. ... if it was changed you make a new query, regardless how many requests are ... The read-actions can then still use a static XML-file ...
    (comp.lang.javascript)
  • Querying keywords in a subform
    ... Thanks to the people who have helped me so far I now have my basic image ... database up and running - and I'm pretty pleased with myself! ... I have added a second table for assigning keywords to each image. ... My problem now is how to query the keywords. ...
    (microsoft.public.access.gettingstarted)
  • Re: Query on Month
    ... I want to query my database to find all employees born in ... a particular month, regardless of year. ...
    (microsoft.public.access.queries)
  • Re: Query on Month
    ... I want to query my database to find all employees born in ... a particular month, regardless of year. ...
    (microsoft.public.access.queries)