Marc, I just tested the following in the sample of RRBYW14 where Razzak has provided a form similar to your scenario (I think).
The original call to the form was this; BROWSE USING SalesTransactions + ARRANGE InvoiceHeader BY TransID ASC, + ARRANGE InvoiceDetail BY DetailNum ASC, + ARRANGE Employee BY EmpLName ASC, + ARRANGE Contact BY ContLName ASC + ORDER BY CustID I changed the call to this; BROWSE USING SalesTransactions + ARRANGE InvoiceHeader BY TransDate DESC, + ARRANGE InvoiceDetail BY DetailNum ASC, + ARRANGE Employee BY EmpLName ASC, + ARRANGE Contact BY ContLName ASC + ORDER BY CustID Everything worked as expected. So maybe check the relationships in your form. Jan -----Original Message----- From: "MDRD" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 29 Oct 2009 07:19:14 -0500 Subject: [RBASE-L] - Re: Arrange By Hi Ed DoitDate is a date field but I also tried DoitStatus which is Text 1, and it will not sort. Doit is the second table, I am using a DB Grid on the first page of an Enhanced Tab. Maybe that is the problem? Not a major issue just can't figure out what I am missing. Thanks Marc From: Ed Rivkin Sent: Wednesday, October 28, 2009 11:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Arrange By Marc, My experience sorting dates is from R:Base 4.0 days. I never liked the way it sorted dates so I created a calculated field in my tables so I can sort dates consistently. I am assuming that "doitdate" in your example is a date field. Here's what I use to sort the field Duedate ((iday(duedate))+((imon(duedate))*32)+((iyr(duedate))*400)-730000) It may seem a bit crude in today's world but I frequently use multi-table forms and the rows with Duedate are presented as desired by sorting on this calculated Duedate rather than Duedate itself. Ed Oct 28, 2009 08:44:27 AM, [email protected] wrote: Hi all What am I doing wrong? I am using the latest 7.6 build but can't get the second table's DB Grid to sort using EDIT USING mainmenu ARRANGE doit BY doitdate Asc Thanks Marc
