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:
00117276
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform