Hi Everyone,

I have routinely used a two table view to delete a parent record and it's child records. Have used the view designer to do this and it works fine. But have just run into a case where I have a parent table and this table has 4 child tables related to it.

When I tried to work up the view in the view designer, it seems to create it okay (somewhat) - and I used LEFT OUTER JOINS as not all the child tables will always have child records.

Anyhow, could not save the view to try it out. Should I be able to do this in the view designer or do I have to do a hand-coded view? or maybe I have to do 4 different views, one for each child table?

Thanks,
Albert Gostick