Dynamic Multiple and Choice fields help
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 :-(
5 replies
-
I already have the Inventory Table
-
I don't think you need a second child layer "Test For (SPK ... " The Test data can be part of the first child layer. I think I would have one parent table Inventory and child tables for the concrete Type Tables Equipment, Video, Audio . And those Type Tables do have the test data as well.
-
Here is one possibility for a solution.
To add tests you click on the Add Tests button and then select the tests according to test category.
Let me know if you have any questions.
Content aside
- 2 yrs agoLast active
- 5Replies
- 111Views
-
3
Following