Posted by dwightsmail on 07/19/06 04:50

hi all, can anyone help me?

I am a relative newbie to sql server and I am more familiar with
Enterprise Manager than QA. I have made many many access databases
though. I am making an asp.net application where by there are a set
number of users, about 80, each one logs in and manages information
within their department.

To get them started a manager has written 10 different hazards that
will apply to all of the departments, and he has written consequences
and controls for the hazards. Each department must have this
information as each will manage and deal with them differently

The hazard information is stored in a main 'hazards' table, and the
consequences and controls are stored in related tables linked by the
'hazardID' from the main table to a foreign key 'hazardID' in the
related tables

What i want to know is if there is a relatively simple way of using a
query to populate the 10 hazards to each department, and to also
include the related table links, i dont mind renaming the departments
names to match each hazard, but i do not want to have to relink the
related tables manually

If anyone can give me any advice to get me started i will be incredibly
grateful

thank you


Table information is below

Hazards
------------
HazardID - identity key field
Hazard - varchar
Department - varchar

Consequences
----------------------
ConsequenceID - identity key field
HazardID - FK
Consequence - varchar

Controls
------------
ControlID - identity key field
HazardID - FK
Control - varchar



dwight

[Back to original message]