If I were king, QuickBase would be my best hope for relational database apps made simple. Sadly, my understanding is that Intuit isnt too keen on taking QuickBase in that direction. Thats sad because if anyone could make building many-to-many relationships simple, Im sure Intuit could.
Whats needed is an interview process that determines what the user is trying to do and then builds a database schema for accomplishing it. Drop in some sample data and the user could play with the new database and make limited changes before finalizing the application. The database would do the heavy lifting while the user could make tweaks where needed.
As all things seem to, this eventually circles back to Microsoft. Its made Access the default database of choice for corporate America, even though FileMaker is probably the better choice for most users.
Access is a failure, at least from my viewpoint, because the program has never really done anything to help make building database applications very easy. Rather, its been Microsoft Excel thats become probably the most-used desktop database of all time.
Sure, Excel is a spreadsheet, but Excel tables probably contain more corporate information than most companies enterprise databases.
If Microsoft, Intuit and FileMaker cant make this happen, maybe the open software movement could take it on, though simple user interfaces have never really been a strong point of "free" software.
I know this is a tough problem, but I dont think my request—simple many-to-many relationships in a database for the masses—is all that unreasonable.