Oh Doug, that is VERY clever! I've always just put buttons to re-sort. No way you thought of that yourself ;-o
Karen > By chance, I found that you _can_ sort a scrolling region without basing it > on a view by using both a Scrolling region and a DBGrid: Build your > scrolling region, locate DBEdits and variables if you want &get it all > fluffed up - > the SR is your data viewing/editing area. Then create a DBGrid on the same > table. Locate the same columns in the grid that you have in the SR - same > position, same width. Make the height of the DBGrid just enough to show > column > headings and locate the DB Grid right above the SR. Click a heading in the > DBGrid and the scrolling region sorts. A test table with 365,000 rows sorts > instantaneously on PK &indexed columns. Only drawback is you can't move the > columns... well, you can in the grid but they don't move in the SR. > (RB 7.6.6.30315, but I suspect it's been capable of this for a while) > Doug
