HELP! DB Design to later query multiple keywords



I am an Access novice, using v 2007.

I need to design a database to store our company's project information in
for later reference for marketing, etc. Each project needs to have multiple
associated keywords from several different categories. The goal is to be able
to run a query specifying certain keywords, and a list of associated projects
will return.

Some of the categories are Sector, Project Type, Materials and Services.

Under Sector would be commerical, industrial, residential, etc.

Materials would include steel, wood, masonry...and so on.

I need a way to assign mulitiple selections from each category to all the
projects, so that later when I need to find an industrial project, that
included steel and masonry work and on which we provided services such as
project management and structural design, I can query that information easily
and it will return that projects A, F and G meet that criteria.

Any suggestions on how to lay out the tables and relationships to make this

Thanks in advance for any help!




Thanks, Steve! You're my new superhero! Works great. I've just spent so many
years in Excel flat files, I'm having trouble wrapping my brain around
relational db design.

Appreciate the time you took to help.

John... Visio MVP

Steve said:
You're welcome!

I provide help with Access and Excel applications for a modest fee. If you
need help beyond what you can get in a newsgroup or if you need quick
help, contact me at (e-mail address removed).


These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie is a known troll who harrasses posters for work. He provides
questionable results at immodest prices.

There was nothing special about his original answer.

John... Visio MVP


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question