i have two tables in DE, where i dragged callno of table bls to table reserve. vfp creates index callno in table reserve.

i'm displaying data from these two tables in page 4 of my pageframe. i have textboxes with controlsource bls.callno and reserve.name.

i want to display reserve.name when reserve.callno=bls.callno. but this does not happen, txtreservename displays the first record of table reserve.

in pageframe click of page 4, i do sele reserve

what did i do wrong? pls help. TIA.