Data Model Help

There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.Hi
http://www.databaseanswers.org/data_models/ may be of help
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Brian" <brian@.nospam.com> wrote in message
news:%23Kbg6XflFHA.2180@.TK2MSFTNGP15.phx.gbl...
> There may be some tools out there already developed that can handle this
> but
> I haven't had success in finding them.
> Essentially what I am trying to do is create a data model that can
> accomodate the creation of a variety of forms to be filled out.
> The end user should be able to create a question and select what type of
> answer it will bne, multi select, checkbox, radio box, free text. Provide
> the possible answers if needed. And then allow the form to be filled out
> and the responses saved.
> That part shouldn't be too tough. Forms may need to be able to be related
> to other forms or multiple forms could make up 1 form to fill out. Like
> form A and D.
> If there is something like this already I don't want to reinvent the
> wheel.
> Also if someone has experience with this type of model has it been good or
> bad.
> Thanks.
>