I need assistance with script.

I am creating a database for stationery products.

We have 5 Groups:

Writing,

Filing,

Paper,

Accessories,

Private label

 

Within the Group there are Catagories so for:

Writing - you have Pens, Pencils, Markers, Art

Filing - you have report covers, binders, expanding files

etc

 

Withing the Categories there are subsets so For:

Pens you have Ballpoint, Ballpoint w Grips, Ballpoint Retractable, Ballpoint retractable with grips, etc

Report Covers - Poly, Paper etc

 

If one selects Writing then I need all other groups the be hidden as well as their corresponding categories and subsets.

If one selects Writing - Pens - then all I need all other categories and their corresponding sub sets to be hidden

 

I have created a form for Groups

Then form for Categories - Writing

then form for Writing - Pens and its corresponding subsets

 

but can not still get the scripting right.