>I am attempting to build a form with fields from Table A (One record per individual) and a grid from Table B (Many records per individual). I do not use the wizard to build the form, but have modified the txtbtns class from the wizstyle library to allow for three search conditions instead of two. I would like to be able to search fields from both tables when using the find button. If the DataEnvironment of the form contains both tables, only the fields from Table A are displayed in the dropdown list of the combobox, allowing only searching of Table A. If the DataEnvironment of the form contains a View built from Table A & Table B, the dropdown list in the combobox behaves the way I wish, but the form behaves as if there are as many occurrences of the record in Table A as there are child records in Table B. If there are three matching records in the grid, I must click "Next" three times before the next Table A record appears on the form. I know there must be a way of doing this, and I'm
>just to thick to see it<g>. Any tips appreciated.Thanks.
>Ken
You've probably used SET SKIP INTO (childalias). If you clear this, then the record pointer will move in the parent table with each skip.
George
Ubi caritas et amor, deus ibi est