Sort unique values in portal from related menu

[clipper]

What I have:

One DB

One field for "manufacturer and car model"

The same in separated fields "manufacturer" and "car models" by calculation from first.

Conditional value list based in "manufacturer" and "car models"

If I select "BMW" in the first pop-up, the second sorts "318, 225, 525, etc"

What I need:

I need to select "BMW" and sort the related values in one portal alphabeticaly and omit repeated values. Now I see "525, 318i, 320, 318i (again), etc"

Is that possible?

Thank you

[Ugo DI LUCA]

Hello,

Use a selfjoin on your "manufacturerandcarmodel" field.

Showuniquerecord = Case(Record_ID = Max(Seljoin::Record_ID),"Model", " ").

and

Sortfield = Case(not Is empty (Showuniquerecord), 1,0)

You could therefore

- use this Showuniquerecord in a Valuelist

- use a portal and display these records. This solution doesn't omit any record, but you can sort the relationship on

A. Sortfield (to show in first the not empty values)

B. Alphabetical sort on Models.

Or you could find a way to index Showuniquerecord and then use a relationship from a constant number field = 1 at left side and Showuniquerecord at right side to really omit the duplicates.

Hope this can help.