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.