Bill, I've been addressing the same problem as you for about the last 7 months. I don't know what the business aspects of your desire are, but there's a long way between now and getting it done. The basic approach is to have all database tables as children of a "MAIN" table. When the request arrives you 'scope' on the request.host to call the appropriate 'main.subtable.find(:all). I can't tell you the PAIN it took me to ferret this out. Kathy
This thread may help http://groups.google.com/group/rubyonrails-talk/browse_thread/thread/9c578165f1511cb3/?hl=en#
--linoj
