Posted by David Portas on 01/17/07 00:11

Blast wrote:
> Ok, i drew out your diagram and my design thoughts are exactly like
> yours. And I was hoping it wouldn't be.
>
>
> Let me explain. I'm using the windows form (.net) for my UI and there
> are no controls that recognize this pattern, at least not right out of
> the box (not to my knowledge).
>

Obviously the UI code has nothing to do with constructing an effective
data model. The right solutions rarely come "out of the box".

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

• Next in forum: Re: Inserting nulls in to table conflicting with rule
• Prev in forum: Trusted Security in a Workgroup
• Thread view: Re: David Portas Reply

[Reply to this message]