I have a quick question on a tricky model for the app I'm working on. I have a Tasks model, and a Task can be assigned to a User; a Task should also know the User who assigned (created) it, and be updatable by that user. The idea is so the View can have something like on a "My Tasks" page:
Assigned by John Smith on June 1st, 2008
Since it has to have two references to the same model (User), one for who has been assigned to, and one for who did the assigning, what association should I be looking at? The associations in Rails are a little confusing beyond the basic belongs_to/has_one/has_many things, so I'm not sure what I should use. has_and_belongs_to_many? has_many :through?
Any help would be appreciated.