Related field in a Record

[ppcalarse]

Hi,

I have 2 fields with 3 repetitions each one.

One field is called Product and the other is Price.

I have created a Calculated field that tells me the lowest price, but I would like that it tells me the name of the lowest priced product instead.

Is there a solution for this?

I know it should be easy.

Also, is it posible to sort the records within the same layout?

I have uploaded my file minimun.fp7 as a sample.

Thanks for your help.

Minimun.zip

[aaa]

Here is calculation field wich you wish. But this calculation depends from number of repiting fields. If you change this number, you must change calculation too.

Minimun.zip

Edited October 13, 2005 by Guest

[ppcalarse]

Thanks,

It worked flawesly.