I have some normalized tables and want to display the combined information on a form. I have a grid used for searching and the info displayed above in textboxes (for editing.) The address info is in one table and the city is in another. I’ve placed some code (locate for fkey = pkey...) in the grid BeforeRowColChange and AfterRowColChange but the display in the textbox does not refresh until the second row/column change. Scrolling record to record, this leaves the textbox display one record (city) behind. How should I address this situation correctly?

Thanks!