Hi all,
I have a table "A" with a field booknumber that points to booknumber in
another table "Books", the relationship is one to many.
if I have the table "A" in a grid and point the ControlSource of the
booknumber to the bookname in "Books", how can I sort the grid by the
bookname and not the booknumber when I click on the column header.
this is the code I use in the Click event of the column header
oGrd = Thisform.pageframe1.page2.grdtableA
oGrd.SetAll("Picture","","Header")
SET ORDER to booknumber ascending
GO top
oGrd.refresh
I want to be able to sort the grid using the bookname from the books table.
I know I can do that by using a view, but any other ideas?
Thanks
HME
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com