>I am trying to convert a project that is using MS Access into VFP7.
>
>In the Access table there is a query with one parent table that has 2 children tables and one of the children tables is parent to 3 children tables.
>
>In VFP7 I tried to have a local view with one parent table with 2 children tables and I get the message:
>"The same table cannot be parent to two child tables"
>
>Is this serious?
>Does it mean that Access queries are better than VFP's?
>Or is there a work around?
>
>Thanks.
Raymond,
I don't know how you are creating your view but it perfectly allowable to do;
SELECT * FROM Parnet PA JOIN Child1 CD1 ON PA.Key = CH1.Key JOIN Child2 CH@ ON PA.Key = CH2.Key ...