5 Replies Latest reply on Jun 5, 2013 1:36 PM by pfroelicher

    sorted list output of related records

    pfroelicher

      We have a formula to produce a cosmetics.

      These formulas have related records, fo_itens, which contain the percentage of each ingredient, the name/description, price etc. all pulled out of our "products"table.

       

      We need a text field, which shows the name of each formula item, comma separated.

      I have managed to calculate this text field with

      (Substitute( List (fo_itens_PRODUTOS::prod_INCI_name ); ¶;", ")

      just fine.

      This field is sorted by the creation order of the product table (PRODUTOS).

       

      However...now I would like that the items are SORTED by another field in fo_itens, which is the percentage. Higher percentages should be listed first.

       

      Any hints how this can be accomplished?

       

       

      Tables

      Produtos Produtos

      Formulas formula

      Formula itens fo_itens (an intermediary table for the many-many relationship between formula-produtos. Here I have the percentage % which goes into each formula of each product.