>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-
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only