>>>
>>>try using VIEWs
>>>also what RI code have u set for the child table
>>>
>>>Arnon
>>
>>could you explain a view, and what RI stands for. thanks
>
>views are sort of like the cursors a regular SELECT SQL produce
>but they have much more power ,e.g. if u update the data in a view u can sent the updates to the parent tables - u can read on VIEWs in the VFUG tips'n'tricks section, oh, and the VFP manuals (actually the manual is not thta bad)
>
>as to RI - that is refrential integrity u various rules that VFP lets u set for related tables (of course u can also write your own)
>e.g. VFP lets u set a father table so that u can not delete a record if it has children in the child table etc.
>
>Arnon

Thank you all for the help, I think that I am starting to learn this thing that u call VFP. Anyway, one small step at a time.

Bob