Re: Cyclical Relation.
Date: Tue, 24 Apr 2001 14:28:40 -0400
Message-ID: <9c4gpr$cma$1_at_bob.news.rcn.net>
from what you have indicated about what you are trying to do, i suggest you have User, SentTo, and Message tables. SentBy can be a FK column from Message to User.
"kk" <kk_at_tuputamadre.com> wrote in message news:3ae5971b$1_at_news...
> User UserMessage Message
> -------- ------------- --------
> IdUser IdMessage IdMessage
> Name IdUser ( who receives ) Date
> Active
Title
>
> Body
>
> IdUser ( user who sent the message )
>
> There is a relation between User and Message 1:M when the user writes a
> message.
> There is a relation between User and Message M:M when the user receives a
> message.
> Can be this a solution??.
>
> Regards..
>
>
>
Received on Tue Apr 24 2001 - 20:28:40 CEST