I created four layouts named Category, Function, Fail, Action.
Related those four tables by One to Many Relationship..
Now I give input in "Category"
Record1: Single Lift
Record2: Double Lift
// One Category has many Functions
Then in "Function"
Record1: Mount to the door / Single Lift
Record2: Attached to the door / Single Lift
Record3: Window glass moving up/down / Double Lift
Already I told that One Category has more Function,
So I make one drop-down list in "Function" (which I make Value List from fields & was fetch from "Category" Records. So see the "/" near the Function records to identify which related record for the related category.)
Then Next, "Fail" table contains One Function has more Fails.
Record1: Fail1 / Mount to the door / Single Lift
Record2: Fail2 / Attached to the door / Single Lift
Record3: Fail3 / Attached to the window / Single Lift
Record4: Fail4 / Window glass moving up/down / Double Lift
Here I required the "Action" table as,
Record1: First I need to choose Category, So I select that Category from (Related Field) drop-down list.
So While I choose "Single Lift", It should need to show only What related functions it has(Sinlge lift has two functions: Mount to the door / Attached to the door - this only need to display) (other functions must not to display in the drop-down.)
And Same While I choose "Fail", What fail related with that "Single Lift" category & that related two Functions only need to display, others dont want.
Give me a solution to do this best!!
Best Solutions much appreciated!!!
Thanks for your valuable time to read this and response,