You are correct, no tables are being updated via these views.
What's happening is the user is doing some data-entry on the last one that's created and I'm manualy updating a table based on what they do.
A straight SQL that doesn't go into a view would be fine, but then of course I don't think you can't edit the data in a temporary cursor. I suppose I could create a temporary table, but the I/O on the hard drive would probably be just as bad if not worse as doing it this way.
I really just don't want to be sludging along requerrying half a dozen views when I know that there has to be a way to do it with one statement.
Unfortunatly my SQL isn't that strong to begin with and this has turned into a rather complicated mess. Grrrrrr........