Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to Many
Message
 
To
13/01/1997 11:44:24
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00017190
Message ID:
00017348
Views:
65
>I have created many one-to-many forms without problems. Suddenly, I have one that WILL NOT WORK:
>
>I have a combo box whose RecordSource is a field from the parent table (committee names). The grid should show members of the selected committees. The InteractiveChange SEEK's the DisplayValue of the combo box in the parent table successfully. However, the grid remains empty. I have the relationship established in the Data Environ., all properties in the grid data tab filled in correctly (checked them 50 times at least). Have hand-filled the data tab properties and let the grid builder do it for me. Have yet to see a single committee member in the grid, even when I first enter the form. When I view the databases from within the form, the relationship shows properly. When I select another committee, the relationship shows properly. Any ideas out there??
>
>TIA.

Hi John,

If the control source of your comboBox is of type field, then u don't need seeking the DisplayValue, as the record pointer is automatically moved. Also if u have the relation set in the DE, u don't need to add the properties refering to the Master and Child tables on the grid, perhaps in the childOrder u are changing by mistake the order needed in the child table for keeping the relation?
Finally, are u refreshing the grid? :)

HTH,

J. Luis
J. Luis Santiago Rodríguez.• CADIS • E-mail: jlsantiago@iserve.net.mx• Ciudad de México.
Previous
Reply
Map
View

Click here to load this message in the networking platform