Comparing fields

[Chris Wood]

Problem: create a comparison of the value in the same field appearing in 2 records.

For example: Each record containd the specifications of different cars. The user finds two machines to compare. I would like to show the specific data for each model (easy) but also to show the difference (+ or -) that exists between, say, the fields for weight, power, length and width.

I can think of clumbsy ways of achieving the comparison; is the an elegant method.

Thanks in advance.

Chris

[Anatoli]

My wild guess is to create search value Flag and enter that to field. So it can be 2-3-4-5... found records.

Create self-relation on this field.

Display portal with those records.

If you will design more layouts, you can sort the portal many ways and present the differences.