I don't believe you can do a join in a lookupfield...