Re: Database design

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Sun, 29 Apr 2007 20:20:00 -0700, Tim Moynihan
<TimMoynihan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi Jason,
Many thanks for your reply. I really appreciate it but unfortunately it does
not solve my problem. On my single table database I have 28 categories and
some of my contacts qualify for multiple categories. I have tried two methods
of filtering by QBE without success. The first was to refer to my category
table and type into the criteria row 27 And 28. The two entries cancelled
each other out; 27 Or 28 worked well for an "either/or" but failed for three
combinations or more.

Reread Jason's suggestion.

Your table design IS WRONG. Jason's design is much preferable. You're
"committing spread***" by having different FIELDS for the categories. What
you need is different RECORDS.

I then created new Yes/No fields for the different disciplines that I want
to combine but this also failed. They could handle an "OR" statement but not
an "AND" and completely failed with three or more options.


You've guessed it. I am a struggling beginner trying to swim in deep water
and I am having a hard time. I want to know how I can select each of my
Contacts who qualify for SAY; Student, Buyer, Seller, LibraryMember,
CharityOrganiser as they are a select band who deserve special recognition.

I have three books that cost me over $500 and none cover this topic!

Look up "Many To Many" in the index. If the index doesn't cover the concept, I
can't say much for the book.

John W. Vinson [MVP]
.

Quantcast