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...