I have two grids on one form. The upper grid contains the company names, the lower grid contains the materials they have available. Stepping from owner to owner updates the materials in the lower grid.

I have two problems.

One) A person uses the scroll bars to look through the owners (upper grid). The record pointer is still on owner A so the materials grid displays those for owner A but the upper grid is displaying owner Z. When the lower grid gets focus I would like the upper grid to display the current record (owner A). I've been working with refresh but so far it causes more problems than it solves.

Two) I would like to have the current record to remain highlighted in the upper grid even though the lower grid has the focus. Is that possible?

Suggestions? TIA