selecting multiples items/adding tables/setup correct?

[kiwilime]

I am trying to figure out how to be able to select multiple items. My projects includes looking at states agencies projects and putting them into a db. I have found there can be an agency that is using a technology. For example, Education is using hand-held application so I would need to be able to select both.

Question on how to link table. And any other suggestions.

Am I doing this right in creating a table for agency, a table for technology, and combining them in a table called Agency/Tech. Then having the Agency/TechID in the StateProjects Table?

What I have so far is.
StateProjects Table, with ProjectID, Agency/TechID, StateID, Application, URL, Description.

State Table, StateID, State

Agency Table, AgencyID, Agency

Technology Table, TechnologyID, Technology

Agency/Technology Table, Agency/TechID, AgencyID, TechID

any help appreciated...

 

[kathryn]

YOur design looks great! What exactly is your question? Do you want to setup a form the allow you to fill in the Agency/Techology table?
Kathryn