>>I have a big project with over 50 tables and one database container (DATA.DBC) with a lot of rules, relations and triggers set up in container. My project has many forms,reports and so on... So far I made my customer happy with every little detail , but here is one request I am having problem with.
>>In DATA.DBC I have relation setup between APP.DBF and WORKHIST.DBF tables based on SSN key. APP.DBF is a master with SSN as primary key and WORKHIST.DBF is slave with SSN as regular index. In some of my forms I have to scroll through grid based on APP and I would like to see related records from WORKHIST.DBF ,easy so far. My problem is to have WORKHIST records ordered by SDATE (another regular index ) not by SSN. If I try to order by any other index, I loose my relation with APP. I am trying to avoid creating view or basing my grid on query and my question is : How can I order child records in grid by another index and not by SSN. I tryied using datainv properties,cursor properties,data properties of the grid and so far nothing is working. Please help....
>>Thank you...
>
>Personally, I would use a view .... but try creating an index for WORKHIST as:
>
>SSN + DTOC(SDATE)
>
>This assumes SSN is character. Use that index for your relation and grid ordering.
>
>-Doug-

Doug & Vadim: Use DTOS(sdate) not DTOC(sdate), because DTOC() will order by month/day/year, but DTOS() orders by year/month/day, which is how you want it. Use a DESCENDING index if you want dates with the most-recent at the top

HTH
Barbara