Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Builder allows fields from one table only?
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00117269
Message ID:
00117320
Views:
22
>> is more robust than a browse. However, in using the Grid Builder, it tells me,
>>"Select a database or free table, and then select fields from ONE table.
>
>>Obviously, I need to display fields from BOTH tables.
>
>
>[snip]
>
>Display one record at a time from the prlink table (in textboxes or whatever) and place the child table in the grid. You may consider using a parameterised view for the child table instead of just linking it directly to the grid. The change the parameter used and requery() every time the record pointer in the parent moves.
>
>If you absolutely have to have your parent and child records in one grid, you could simply combine them in an view. However to me this would seem confusing, i.e. seeing "Jerry Ritcey | emp no 144|" several times beside each vacation record.

[snip]

Jerry, I really appreciate your help. I have created the grid as you suggested, populated with fields from Vac.dbf. I have provided a combo box for the user to select an employee from. The combo box RowSource is prlink.nmbr,fname,lname. A RELATION is SET TO prlink.nmbr INTO Vac -- Vac is INDEXed ON nmbr+DTOS(date), so that the records should appear in ascending date order. I set this relationship up in the DE of the form. In the ValidEvent of the combo box I have the code: ThisForm.Refresh(). However, the records DON'T appear in date order in the grid. This is needful in order to be able to easily follow the chronology of vacation history for the selected employee. I have made this work using BROWSE; so, it's probably some little detail I'm missing with respect to the grid. Appreciate the help. Thanks.
Chuck Henry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform