Is there a product in the "cheaply deployable" range (say \~\$100) that you can point at a significant SQL Server database and it parses the foreign key relationships and presents a table viewer in which the values in the foreign-key column automatically hyperlink to the relevant table? And this tool allows basic CRUD editing, searching, and sorting? Just like Access, but with navigation?
(Or do I have to create a Rails app for a db that has several hundred tables? Given that Rails doesn't automatically generate the FK relationships, you're talking about days of work.)
[Update: ]{style="color: #ff0000;"}[I'm not talking about a tool for me, necessarily -- have SQL, can travel and all that. And, sure, with Rails I can probably turn out a dozen or so forms (maybe more) in an 8-hour day. But, with a database with \~200 tables, you're talking about me charging my clients thousands of bucks just to make simple Web pages. My requirement is ad hoc navigation through a database, with CRUD at the table level and a "development time" of no greater-than-a-day for a 200-table database. Really, very close to Access, but when there's an FK in the table the person doesn't have to say "Oh, okay, this line item has InvoiceID 256 -- open the Invoices table, search for 256 -- Oh, okay, that has a CustomerID of 538 -- open the Customers table -- let's see, OrganizationID 23 ... " Just:]{style="color: #000000;"}
LineItemID InvoiceID LineItemColumn LineItemColumn2 1 [[256]{style="color: #0000ff;"}]{style="text-decoration: underline;"} foo bar
...where that link leads to...
InvoiceID CustomerID InvoiceColumn InvoiceColumn2 256 [[538]{style="color: #0000ff;"}]{style="text-decoration: underline;"} foo bar
... etc ...
[Update: ]{style="color: #ff0000;"}[I solved the problem using Rails]{style="color: #000000;"}