Terry,

Thanks for all your help. It is very appreciated.

All the best,
Don

>Heh Don
>
>visually setting relns of the tables in the DE as described does actually set these values in the grid, if I remember correctly: one of the advantages of visual building.
>
>You seem to be doing everything OK. As you said, you ported from VFP8 (where it worked fine) to 9, and I see you have SP1, so I don't know what more I can add, still being in a 7 backwater and not knowing many of the vaguaries of 9.
>
>Terry
>
>>Hi Terry,
>>
>>Thanks again for your help on this one. I'm not using DE. I'm using the LinkMaster and ChildOrder props on the grid to control the relationship. Relationship works good as I move from one employee to the next, it only shows the transactions for that employee. So that part is working pretty good.
>>
>>Thanks,
>>Don
>>
>>>OK Don
>>>
>>>I don't know how you're controlling the relationship of the parent and the grid. Did you drag the tables into the DE and leave their relns alone?
>...