Using 3 Databases

[Center]

Want to use 3 databases each with many fields. Am getting correct genus & species (4 species of the genus I am searching for) but wrong family on first (Abarema brachystachia Wylld) Family is correct on the others 3.And am getting nothing from third. I wrote
select 1
use Gspecies index G alias primary
*indexed on genus
select 2
use Ggenera index H alias secondary
*indexed on genus Has a field family too
select 3
use Gfamily index I alias third
*indexed on family
Select primary
Set relation to genus into secondary
Select secondary
set relation to family into third
go top
do while .not. EOF()
disp primary->genus,primary->species,secondary->family,third->fama2uthor
*line above is not broken in program
select primary
skip
wait
enddo

 

[Center]

Please ignore my post..........
I got it.
select 1
use Gspecies index G alias sp
*indexed on taxon
select 2
use Ggenus index H alias ge
*indexed on genus
select 3
Use Gfamily index I alias fa
*indexed on family
select sp
set relation to genus into ge
select 2
set relation to family into fa
select 1
go top
do while .not. EOF()
disp sp->taxon, sp->taxauthor, sp-subsp, sp-sspauthor
disp ge->family, fa->famauthor
skip
wait
enddo

(sure wish I could use trim on these fields.)