>> select PKValue from yourtable ;
>> where your_filter ;
>> order by YourOrder ;
>> into cursor tmpCursor ;
>> nofilter
>> use dbf("tmpCursor") in 0 again alias NumberProvider
>> use in "tmpCursor"
>> select NumberProvider
>> index on PKValue tag Linker
>> select (yourgrid.recordsource)
>> set relation to PKValue into NumberProvider
>> yourgrid.columns(n).controlsource = recno("NumberProvider")
>
>I tried this and it didn't work for me. It dispays an empty column. My grid is created with wizard. In data evironment is the table named gk_konta. After that I insert one column for count number. I move it to the leftmost of the grid. Than enter your code in form.init and play it. My column for count is empty. My code is the following.
>
> select sif_konto from gk_konta ;
> order by sif_konto ;
> into cursor tmpCursor
>
>* use dbf("tmpCursor") in 0 again alias NumberProvider && I rem this because it gives me an erro message saying that table is already open ????
>* use in "tmpCursor"
> select tmpCursor
> index on sif_konto tag Linker
> select gk_konta
> set relation to sif_konto into tmpCursor
> thisform.grid1.column6.controlsource = recno("tmpCursor")
>
>Any idea ?
select sif_konto from gk_konta ;
order by sif_konto ;
into cursor tmpCursor
if used("NumberProvider")
use in "NumberProvider"
endif
use dbf("tmpCursor") in 0 again alias NumberProvider>
use in "tmpCursor"
select NumberProvider
index on sif_konto tag Linker
select gk_konta
set relation to sif_konto into NumberProvider
thisform.grid1.column6.controlsource = [recno("tmpCursor")]
If you cannot use numberprovider to index it then column would likely to be empty (no matching).
Cetin