>>>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

Gary, try a parameterized grid for your child1 and child2 records instead of letting the grid handle relationships. That way you can put any data you want in.

The asterisks are the same as you will see if you do a Browse with 'set skip on'.

HTH
Barbara