linking controls to data sources

I'm not the most knowledgeable in VFP but I have two stand alone tables that I need to allow to be browsed. I've made a form and to set things up put this code in the load procedure:

USE c:\results.DBF
SELECT b
USE i:\probill\btn_note.DBF
SET ORDER to BD && BTN+DTOS(NOTE_DATE)
SELECT a
SET RELATION TO btn+date INTO b

This form is basically to let users to what I'd do with the following command:

Browse fields results.btn, results.cc, btn_note.note

On theform I put a grid control on the form with it's source set to results.dbf and a textbox with it's source set to btn_note.note.

When I run the form how can I get the textbox to update to display the note field from btn_note corresponding to the record in results the grid is showing?


.

Loading