Hi Rimantas,
I'm doing exactly what you ask. I have the same problem: a table with clients(Id PK) and a table with TaxForms ( TaxId, Period, ClientID ). I have to show a browse with all the forms for a given Tax and Period... but the browse should be ordererd by ClientId OR Clients->ClientName. So I build a new pair of temporary indexes using FOR ... WHILE to make them faster. Following the piece of code.
Select M303
Set Relation To Field->CodEmp Into Empresas
// Index On Field->CodEmp Tag 'TCodEmp' For Field->Ejercicio == cAnio Temporary
ordCondSet( "Field->Ejercicio == '"+cAnio+"'.and. Field->Periodo == '"+cPeriodo+"'", &( "{|| Field->Ejercicio == '"+cAnio+"'.and. Field->Periodo == '"+cPeriodo+"'}"),,,,, RECNO(),,,,,,,,,,, .T.,, )
ordCreate(, "TCodEmp", "Field->CodEmp", {||Field->CodEmp}, )
// Index On Field->Empresas->Empresa Tag 'TEmpresa' For Field->Ejercicio == cAnio Temporary
ordCondSet( "Field->Ejercicio == '"+cAnio+"'.and. Field->Periodo == '"+cPeriodo+"'", &( "{|| Field->Ejercicio == '"+cAnio+"'.and. Field->Periodo == '"+cPeriodo+"'}"),,,,, RECNO(),,,,,,,,,,, .T.,, )
ordCreate(, "TEmpresa", "Empresas->Empresa", {||Empresas->Empresa}, )
Go Top
This works OK. I have used the functional form of INDEX because I replaced the variable part of the filter expresion with constants.
Hope this helps,
Carlos.
There are 2 tables ( DBFCDX RDD ) - 1-st header of documents and 2-nd - variuos items in documents . The relation between them is Doc_Id . The first table have field DocDate . To speed some search of movement of needfull item in needful month it can be better in this way - DocItms->ITEM + dtos( DocJourn->DocDate ) ... But I don't - it's possible or not . At this time I'm running seacrh through period of documents and looking inside DocItms ( dbseek( DocJourn->Doc_Id + cNeedFullItem ) ...