Re: Dynamic structure of a table?!!

Hi and thanks for your replies,
Message for Andreas Sheriff ! : I did not understand your solution
completely but seems nice,would you please tell me more or direct me to
proper source?
And reply for Carlos: I think there is only one entity called "Form".This
is an conceptual modeling(not design) so there is no *Entity* called filed.
You can say that I map the original ER to a logial design with two tables
named by: Form and Filed. But this has the same problem with EAV method that
I have mentioned in original post.
-Thanks

Carlos wrote:
>My approach:
>
>Parent Entity 'Form' with attributes (like size, colour, etc...)
>and
>Child Entity 'Field' with relationship dependent to the parent entity
>plus Field Identificator with attributes heigth, width, X pos, Y pos,
>colour, prompt...
>
>With a design like this, you should be able to manage n forms with m
>fields within.
>
>HTH
>
>Cheers.
>
>Carlos.

--
Message posted via http://www.dbmonster.com
.

Relevant Pages

  • Re: design standards?
    ... different resolutions problem when I wrote the original post, ... putting in 600x800 and 1024x768 so that any design could be graded based on ... There is no such standard. ... Is the page so large that it won't fit on a standard resolution ...
    (microsoft.public.frontpage.programming)
  • Re: Visual Studio 2005 is a memory hog!!
    ... >>> Best regards, ... >>> Carlos J. Quintero ... design and document much faster. ...
    (microsoft.public.vsnet.general)
  • Re: Run macro at startup
    ... Productivity add-ins for Visual Studio ... >> Carlos J. Quintero ... design and document much faster: ...
    (microsoft.public.vsnet.general)
  • Re: Windows XP Styles
    ... Carlos J. Quintero ... >> Best regards, ... >> Carlos J. Quintero ... design and document much faster. ...
    (microsoft.public.vsnet.ide)
  • Re: Auslessen Enter-Key
    ... Best regards, ... Carlos J. Quintero ... design and document much faster. ...
    (microsoft.public.dotnet.framework)