>>I have a parent table filling a grid and a second child table grid
>>in a one to many relationship. The parent table grid ends up with
>>extra rows filled with asterisks accounting for the number of
>>child records.
>>
>>I just love VFP. Any suggestions?
>>
>>Gary
>
>if the 2 tables are in your DE include a relationship between the 2 tables, I leave 1-to-Many property set to .f. to avoid the multiple lines in the parent grid. The child grid still only displays the related records if you have properly defined Link-Master, child order and RelationalExpr in the child grid properties.

Thanks Mark. However I have a third table which
is a child of the second table. So when I click
on one of the First childs records I want the
data from the second child to show up. If I don't
have a 1 to many relationship then good 'ol VFP
won't let me click on the other records. It always
returns to the top record.

Any more ideas? This does'nt seem like something
good old microsoft should have overlooked.

Gary