We have been using this idea internally for years in a winforms app. Our base product is very soft and intelligent, allowing you to basically design the database and not have to worry about the UI. Once the data structure is in place, you just add items to the menu that point to a view/table/sp and the interface is done.
The interface does things like automatically give a lookup window for FK columns, a date picker for datetime colums, a checkbox for bit, provide all neccsesary navagation buttons, etc. You can then change column/form lables, hide columns, add hyperlinks, add buttons, etc. Parent/child layouts can be specifically defined, or can be told to generate automatically based on partial PKs containing an FK to another tables complete PK.
There is a lot more functionality we've built in over the years, allowing us to very quickly develop and deploy applications. A side effect of this has become the ability to throw our tool at existing databases to provide extended functionality for existing applications instantly.
We are in the process of polishing it and are going to offer it for sale toward the middle of this year. If anyone is interested you can get some minimal further info at http://www.datasofttools.com (excuse the unfinished site, as I said we are looking at mid year to release to public).