Table structure?

[Ruslan Zasukhin]

On 4/29/06 5:19 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

> If I have understood it right, if you have a 1:M between T1 & T2 two or more
> items in T1 can't have BinaryLinks to same items in T2, I need a M:M
> relation for that, right?

Yes. Actually this is true for FOREING KEY and ObjectPtr.

> However, when most records on left side really are
> like 1:M you don't want to setup a M:M just to cope with the few.

> I am trying to deal with this by creating an alias table holding the
> alternative items, and with BL I think that can be easy to work, hopefully.
> But I am still learning this new tool so just have to experiment.

For Alias Table may be better to have

    Country         Alias
         1          M
                    (Alias, ObjectPtr to Country )

 
> It is hard to break old habbits! I just have a support case for one of my
> program where the customer want to have her "old" program back as the new
> works differantly, and you know when users get frustrated how much useful
> info you get from them :-)

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]