2 Replies Latest reply on Oct 30, 2015 1:57 AM by Suresh

    Related field not listing in Next Layout  // Matters Most

    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