Parameter Query - Multiple Tables

  • Thread starter Thread starter tR
  • Start date Start date
T

tR

Background:
In my datebase I have the following tables:
"Notes" - from different books
"Topics" - the topics (Cures, Beliefs, etc) assosiated
with the notes
"Topic1" to "Topic5" - each note can have up to five
topics, based on a drop down list from "Topics".

Problem:
I need a parameter query that will show all the notes,
that have the same Topic (example "Cures")from all 5 of
the "Topic * " Tables.

tR
 
If I understand correctly, you have a Topics table with multiple columns to
record differing Topics (up to five). If so, you will continue to have
problems with your querying (and forms, and reports, and code), as you will
have to inspect every one of the columns to see if a topic appears in any
one of them.

A more normalized design (if I've correctly understood what you have now)
would have a table that holds one row per Topic X Note combination (did I
get that right? you have one Note that can have up to 5 topics?). With a
design like this, a simple query shows any and all rows (i.e., Topics) for
any selected Note.

Good luck

Jeff Boyce
<Access MVP>
 
You did understand correctly, but I do have a table for
each Topic X (i.e.) Topic 1 table, topic2 Table, etc. My
query still doesn't show all the rows, from all the
tables, for a specific topic.

My Topic x table - has three colums:
Topic X ID - autonumber and primary key
NoteID - i.e. the note it is connected to in the "Notes"
Table
Topic - the topic it is connected to in the "Topic" Table.

Thanks for your help,

tR
 
I'm sorry, I misunderstood. You have FIVE TABLES, one for each topic?!?

If so, I repeat, stop what you're doing and spend some time looking into
normalization (call up KB article # 100139 at
http://support.microsoft.com

Your data design is what's causing you so much trouble coming up with a
suitable query.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top