pfroelicher

sorted list output of related records

Discussion created by pfroelicher on May 28, 2013
Latest reply on Jun 5, 2013 by 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.

Outcomes