Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Asterisks in parent grid when using child table - soluti
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00058709
Message ID:
00058923
Views:
34
>I have a parent table relating to a child table with an ID field.
>I have many child records to one parent. I have a test form with
>the parent table and child table in separate grids. With 1 to many
>enabled the parent table has asterisks for the number of child records.
>When 1 to many is off only one of the child records can be selected.
>Previously others suggested I populate the child grid with a
>parameterized view. This didn't seem like an elegant solution to me
>because I would think it would take too long to repopulate the child
>grid.
>
>Solution? Maybe?
>I put a SET SKIP TO (nothing) with the parent table selected and
>everything seems to work. I hope so.
>
>Gary
Gary,

You could dump the relationships in the DE for the fomr and use the child grid's RelationalExpr, ChildOrder and LinkMaster properties to deal with the relationships inside of the child grid.

I would also say to you, don't dismiss the parameterized views until you've tried them, they are very fast.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform