>I have a GRID that I have sorted by last name, first name that is contained within a Pageframe. The underlying table is Keyed on Familyid (Seq#). How do I get the maximum number from the Family table without changing the sort order and inserting a new row.
use the MAX function. Be aware that this function moves the record pointer, so you will have to restore it afterwards.
Erik Moore
Clientelligence