4 Replies Latest reply: Mar 5, 2014 5:05 AM by Joseph Garner RSS

    Link two fields from one table, to one field in the other

      Hey, run into a small problem that I hope is easily solved.


      So I've got one table that has TableID, AllocatedWorkerID, ReportedWorkerID.


      The Allocated and Reported IDs are linked to the same table, which is Users, and are linked by UserID.


      I need to be able to see what user reported the work, and what user has been allocated the work, so I can't just load them both "as UserID" or anything, so I'm a bit stumped at the moment.


      Also the database is designed by someone else, and do not have the ability to change the architecture of it.


      Thanks for any help.