Vivian,

The best way to do this is to set a relation from the first table to the second table. Then when the record pointer moves the the first grid the record pointer will also move in the second grid. You may have to refresh the second grid to see the new records.

Hope this helps

Jeff

>I have 2 grids on the form, one is to display customer name, the other is to display their monthly payments for 24 months. I have to create 2 grids so that when I scroll horizontally on the second grids to look at the payments, I still can see the names (otherwise when I scroll to the right, the first column will be gone).
>
>Anyway, what I want to do now is when I scroll up or down on the first grid, I want the second one to be scrolled too so I can see the matched data for each record. How can I do that?
>
>Thanks a lot for any help!