>>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
>
>
>Open the DE, right-click on a blank spot and choose properties. Find the Parent-child cursors and set the 1-to-many property to false.

Jerry
Thanks for the tip. That takes care of the duplicate parent. Now if I can just beat this child search thing... Over the years I find I have become an unofficial support person and help desk. I 'used to be' an analyst and a programmer. I am telecommuting one day a week now and I'm slowly getting back into it. Thanks again.