>>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.
Thanks for the info Jim. I will try the other method you suggested.
As far as the parameterized view would that be something I put in the
parent grid change record event so I reselect the child table each time?
thanks Gary
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement