>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.
No it just means that view designer is really inefficient up to VFP7. Most of the people actually do not use the designer for it can't handle many types of SQLs. If you create your view in code than it'd work. ie:
open data testdata
CREATE SQL VIEW v_orders as ;
select * from force orders od ;
inner join customer cs on od.cust_id = cs.cust_id ;
inner join employee emp on od.emp_id = emp.emp_id ;
ORDER BY od.cust_id, emp.emp_id
Here testdata!orders made a parent for customer and employee.
Cetin