General information
Category:
Coding, syntax & commands
Title:
Multi-table delete view possible?
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only