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