July 16, 200916 yr 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.
July 16, 200916 yr 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?
July 16, 200916 yr Author 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, 200916 yr by Guest
July 16, 200916 yr Author 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?
July 17, 200916 yr Author 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 ?
Create an account or sign in to comment