Database structure

[Luc Ferrari]

Rookie question :

I want to make a database for the evaluation of occupational safety of
different jobs

Job 1 : Example : "Installing electrical cabinets & cables"
I want to split the job in tasks : example "Task 1: Installing cable
ladders"
Each task can have multiple risks attached to it : example risk
for Task 1 : "Falling from height"
For each risk there are different sub-risks : example :
"Falling through the roof"
Four each sub-risk there are different preventive
measures that can be coupled with the sub-risk : example " use safety
harness"


The risks, sub-risks and preventive measures are all selectable throug a
table (or extra items can be added).


So how do i set up such a database.
I want to enter the data through a form, in a easy and clear way.
Are there examples with the same structure available ?


Thanks for your replies,

Luc

 

[Allen Browne]

Answered in m.p.a.tablesdbdesign