AnsweredAssumed Answered

Related field not listing in Next Layout  // Matters Most

Question asked by Suresh on Oct 28, 2015
Latest reply on Oct 30, 2015 by Suresh

Dear All,

 

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.

So,

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,

Suresh

Outcomes