Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One-to-many search problem
Message
 
To
27/03/1998 13:13:16
Ken Mears
Calif Dept of Fish & Game
Sacramento, California, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00087743
Message ID:
00087766
Views:
34
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform