I need to set up a commission check list system for equipment and it seems to me the best way to do this is with Dynamic type choice fields.  To give an example:

I have an Item in my Inventory table eg:  A TV

Various tests are required during commission phase.  For example:

Under Equipment Tests there could be:
Is it level Y/N
Is the bracket secure Y/N

Under Video Tests we could have:
Display Image Y/N
HDMI  Input Y/N

Under Audio Tests we could have:
Speakers L/R Phase Y/N
Microphones Level Set Y/N

And so on.

In my Inventory Table I would then pick the various Tests that apply.  So a Microphone would not require an Equipment Check for example but it would need the Microphone Level in the Audio Test group.

I would welcome any advice, ideas, suggestions on how best to set up the table structure in terms of relationships.

My thinking so far is:

Parent = Inventory (TV, Microphone...)
    Child = Test Type (Equipment, Video, Audio....)
        Child = Test For (SPK Phase, Mic Level.....)

A screenshot of a paper version:
 

Apologies for wordy post :-(