sorting portals

[Rob 7 Collins]

Is it possible to sort a portal based on related fields?

For example, if I have 3 tables:

tblHotels (fields: key, name, rating)

tblAmenities (fields: key, type)

tmapHotelsAndAmenities (fields: key, hotel.key, amenities.key)

If I have a layout based on the Hotels table, with a portal to the map table, which is populated with the Amenities type field, how can I sort based on the type field?

Sample file attached.

manySort.zip

[-Queue-]

Define a calculation field in tmapHA, which 'evaluates from the context of' rmapHA, of rgAmenity::amenity. Set your portal to sort by this field.