Table Sort

[ron G]

I have a LAYOUT based on a table (STOCKS)

Stocks holds 2 fields: symbol and name

On the layout I have a mergefield that shows the stock name and buttons for navigating to previous and next.

Question: "How do I get the mergefield to show the names in alphabetical order?" I have sorted the underlying table (STOCKS) and yet it does not appear to be effective.

This is something pretty fundamental that I am missing. Thanks for reading.

[mr_vodka]

Dont quite follow... The merge field should be displaying the name of the current record's stock name. Is the merge field from a different table occurrence? Are you using a table view with a merge field in the header?

[ron G]

The merge field is also from STOCKS table.

I also tried deleting the merge field and replacing it with STOCKS::stkName field.

The current layout sort order is on stocks.pk. I can change the Stocks table sort order to be by stkName but it doesn't change the layout sort order.

Same result.. no sort...

Edited July 16, 2009 by Guest

[ron G]

Above is the portal on the STOCKS layout. It is based on a self join -- ie, Stocks2

Below is the STOCK Table. I sorted it on stkName so it looks ok.

But when I navigate via the 'arrow' buttons at the top of the layout, stkName appears in PRIMARY KEY order. In other words it shows:

Apple, Ford, Saskatchewan Potash, United States Oil... etc. I want it to show in stkName sequence. There doesn't appear to be any way to change that order to the desired stkName... Or, is there?

[ron G]

I got it. I needed to change the sort Language to UNICODE. Why doesn't English work? All the names are in English. What gives ?