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

Click here to load this message in the networking platform