Bernie, Answer to second question first: Use a form expression in the format:
Varname TYPE = (partno) Whenever the user clicks on a different row the variable "varname" will take on the value in the column partno. Answer to first question: The way I've handled this with a region is to place two buttons over columns I want sortable, one with an up arrow and one with a down arrow, stacked on top of each other. They have different component IDs. I base the region on a view. The on-after-start code hides the up arrows and makes the down arrows visible (indicating the current sort is in ascending order.) The code behind the arrows will: a) PROPERTY TABLE tablename 'CLOSE' b) DROP VIEW viewname c) CREATE VIEW viewname with the desired sort order d) PROPERTY TABLE tablename 'OPEN' e) hide the opposite direction arrow, show the new arrow f) RECALC VARIABLES If you want to get real fancy, you need to remember which row the user was on when they clicked the sort button and then reposition to that row after step d) above. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Monday, June 30, 2008 9:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Rearrange or ReSort If I bring up a form with a region that has several columns and then I want to re-sort them by any of those columns, how might I accomplish this? After re-sorting, I need to capture the row (Part Number of the row) that the user selects. I am thinking something along the lines of when you do a browse and click on a column heading, it sorts the rows by that column. Or if I use the Browse command, is there a way for the user to click on a row so that I can get a return value to know which row they want? Bernie Lis
