I am working on initially configuring our Ivanti Service Manager system and I am having trouble understanding some aspects of business object relationships, so I'm hitting a wall trying to accomplish what I want to do. This is one example of what I'm wanting to do. I created a Site business object and added fields for physical location details such as street address, city and zip code, and technical support team responsible for that site. I then created a N:1 relationship between Department and Site to reflect that a department can only be located at one site, but there can be multiple departments at one site. I created a link field in the Department business object named SiteLink which stores the RecID of the Site record. I then created a form in the Department business object and I am able to add the Site fields via the relationship and see the Site data as expected, so that part works fine. Now, I want to save the department info in the Employee profile records, which I can do via the existing relationship between Employee and Department, but what I can't figure out is how to get the Site data, which is associated to the Department records, to the Employee form, because there's no direct relationship between Employee and Site. I tried creating a relationship between Employee and Site, but I don't get the data I want because of course there's no association between the Employee record and Site record. How can I establish that relationship between Employee and the Site data based on the Department data stored in the Employee record?
Hopefully that all makes sense.