Hi all, I know how to use grid with linkmaster and relationalexpr to show:
One-to-Many Relationship in Same Form.

But I want to sort the Child Alias in another order, but it will make the grid show no data!!

For example, a Library system, Checking a Book Borrow history:

Book [Book_ID, ...]
/|\
BookHis [Book_ID, BorrowDate, ....]

So, the grid designed as:

.Recordsource = [BookHis]
.LinkMaster = [Book]
.RelationalExpr = [Book.Book_ID]

It works fine, but of cos, the borrowdate will be shown as ascending order as Natural input..
But of cos, show the descending order on BorrowDate will be best..

Well, once I do the code:

Select BookHis
Set order to BorrowDate Descending
Thisform.refresh

Then, the grid data all disappear or show all data.. >_<
Since the grid allow user to add new record on BookHis, I can't change it to SQL-readonly cursor to show..
What should I do?!