normalization - two linked fields in one table

From: Trooper <andrew_zx5_at_NOSPAMyahoo.com>
Date: Mon, 11 Nov 2002 06:40:41 GMT
Message-ID: <JhIz9.796567$Ag2.27051080@news2.calgary.shaw.ca>

I'm setting up a small web based program to help manage "Tasks" between family members. Kind of like Bugzilla, but on a way smaller scale.

My problem is that a "Task" has two fields in it that relate to the same table:

Task

---

TaskID
assigned_to
poster_id

User

---

UserID
name

assigned_to and poster_id are linked to the UserID. What this means is that it
should be keeping track of who posted the task and who it's currently assigned
to.

This works in my head, but then I try to write a query and can't figure out how
to pull a name from the User table for each of the two fields in the Task table.

If it matters, I'm using an MS Access database (I told you it was small-time),
but I could just as well use mySQL if I have to.

Any suggestions on this would be appreciated. Trooper

10-Nov-2002

---

Received on Mon Nov 11 2002 - 00:40:41 CST