HELP with automating database table with a backend

[eluser]dippy[/eluser]
The idea here is to have a backend and once logged in there will be an option to add a new service category. When a new service category is added to the services table in the database the application will create a new table in the db for that service (for vendors/clients that will be in assigned to that service). Then ask the user/admin what fields are going to be used for this service, create the fields in the db and from there it will generate a simple form with labels and input boxes so when the user/admin adds a new vendor and he wants to assign that vendor to a service that form will show up with the correct fields from the db.

is this a possible?

i would like to have it so the user has control of what fields and info they collect from the client/vendor for that particular service.

i was going to hard code in what fields they will need for each service and create the db tables according to the form fields. but it would make life a lot easier if the user had control. it would pretty much be a scaffolding section for just adding a service.