Inner Join and Relationship problem

Results 1 to 2 of 2

Thread: Inner Join and Relationship problem

  1. #1
    Jason Guest

    Default Inner Join and Relationship problem

    Hi,<BR>I have a table with some fields including WinnerID and LoserID. I want both of these fields to be related to a field called MemberID in a second table. Access(2000) wont allow 2 relationships in the same table that both point to the same field in a different table. How do I overcome this?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default with better database design!

    How about the new table with MemberID only and a flag saying whether the Member in question was a winner or loser.<BR><BR>Hard to say exactly what you need without knowing more about your data...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts