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

That sounds great Barbara. What's a
parameterized grid?

thanks Gary