*snip*
>I'm often confused in making things overly complex and lengthy and, in this case, I'm probably guilty of going too far in the other direction trying to make things concise.
>
>Each of the five databases for the plants have 8 remote views. In each case, all eight views are identical to their counterparts in each database. However, within a given database, each of the view is very different in terms of the retrieval critera. For example, one is based on shop order, another style, another, tufted width, gauge and code, and so on.
>
>Could I use GENDBC against one of the modified databases (after fixing the view), then, with a small degree of modification run the resulting program to create the other four databases. Yes, and in fact, I'd done that. I was looking for something that was quicker and easier to do. I think that my solution fits the bill nicely.
>
>The structures and retrieval parameters of the tables are indeed identical between corresponding (and identically named) views. Non-corresponding views are very different.
>
>This wasn't really a big deal. What was happening was that I'd have to run some tests, the underlying structure would be changed and my test would blow up. Naturally, so would I (^&$&^*$$# you folks never told me this was change! DBA comes in my office apologizing profusely, etc.) Then I'd have to go through the "fix the five views" process. It just got to be a pain.
>
>Before anyone jumps in with, "Well, they should've planned better", I'd agree completely. However, the nature of this project is such that even at this point (after a year of work) it's a given that some changes will be required. So having this solution is going to be a time saver for me down the road.
>
>So the bottom line is that I just got tired of doing the same stuff over and over again.
>
>Is this clearer?

Not really but after 6 hours in a mall with my 3 and 1 year old and no store having had the forethought to plan for stroller traffic when designing their layout has got me frazzled, so I would worry about it. :-)

IAC, you have a solution that both works and is quite elegant in its implementation.

Have a great holiday/vacation if you see before you leave; otherwise, I hope you had a great one.