selecting multiples items/adding tables/setup correct?
selecting multiples items/adding tables/setup correct?
(OP)
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...
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...
RE: selecting multiples items/adding tables/setup correct?
Kathryn