Is there a Drupal module for Forms with powerful CRUD style behaviour?

Question

We are building a website that contains a large number of database tables that need to be edited by the CMS administrator. Some of the tables are fed by form submissions from users on the front end of the website. Some of the tables are purely in the CMS and are used to create custom modules on the front end of the website.

Although there is a forms module in Drupal, I think our requirements cannot be met by it. Does anyone know of a system that allows forms to be saved to a CRUD style database with the following features?

1. Export of all database fields.

2. View a summary of the records in a filterable table.

3. With paging

4. You can have one to many relationships in records eg

To code this manually for 10 forms is A LOT of work. Particularly the one to many relationships. If there is a powerful module available it would save us writing one.

Answer 1

I have not used it at all so far, so I have no clue if it fits your needs, but the Auto Admin module seems to offer at least some of the features you are looking for.

Answer 2

You should look at CCK and check that doesn't meet your requirements before building something bespoke. All of your requirements can be met with a combination of CCK, Views, and a bit of tweaking.