1 Reply Latest reply on Aug 20, 2014 10:02 AM by philmodjunk

    Layout template challenge

    gjbdjc

      Title

      Layout template challenge

      Post

           My company produces many products and each product needs one or more of several quality tests.

           I would like to set up a "template" for each product, so that the quality test layout shows only the tests need.

           Example:

           Product 1 needs Test 2, 5 and 8

           Product 2 needs Test 2, 6 and 9

           When I go to the Quality Test layout and select Product 1, only the fields for Tests 2, 5 and 8 are available???

           Does that make sense? 

        • 1. Re: Layout template challenge
          philmodjunk

               Start with these relationships:

               Products-----<Product_Test>-----Tests

               Products::__pkProductID = Product_Test::_fkProductID
               Tests::__pkTestID = Product_Test::_fkTestID

               You can place a portal to Product_Test on the Products layout to list and select  Tests records for each given Products record. Fields from Tests can be included in the Portal to show additional info about each selected Tests record and the _fkTestID field can be set up with a value list for selecting Tests records by their ID field.