Using the same FK in a table more then once

From: <miklesw_at_gmail.com>
Date: 22 Sep 2006 05:04:28 -0700
Message-ID: <1158926668.480075.261540_at_b28g2000cwb.googlegroups.com>

Hi,

I've got a table [User] with which is related to [Character] by 2 relationships. Now, Access seems to be complaining about this and is displaying the table twice with different aliases in the Relationship view..

The relationships are CurrentlyOwns and Owned. I went for this appraoch to avoid using LAST() each time I need to get the current user.

Academically speaking.. is it acceptable to have this scenario?

Thanks,

Mike

. Received on Fri Sep 22 2006 - 14:04:28 CEST

This message: [ Message body ]
Next message: paul c: "Re: 3 value logic. Why is SQL so special?"
Previous message: pamelafluente_at_libero.it: "Re: Idempotence and "Replication Insensitivity" are equivalent ?"
Next in thread: -CELKO-: "Re: Using the same FK in a table more then once"
Reply: -CELKO-: "Re: Using the same FK in a table more then once"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message