Hey so I have an odd issue. The system I inherited has been created by three different people and I guess one of those people decided to go against the already existing system. For one of the columns in this system, namely the agent column of the order table, it sometimes references the userID (which it should be doing and which I'm very happy with) and sometimes references the username (which I can't change at this point so I have to live with it) of the user table.
The problem comes in that, at some point, I will be changing the older systems so that they match the newer systems as far as the frameworks they use and the style, but that won't be for a while. In the meantime I need to be able to run reports with the order, associating the correct user to it. I would like to be able to simply go order.agent.blah like I do with everything else, but I'm not sure if that's possible.
Would appreciate any advice on this matter. I didn't see a way in the documentation, but I'm hoping I just missed it.