Suppose I am using relationships for specific classes where the student in a class (organization) may not have a start and end date. Is there a way for me to look up a particular class and globally update all the students/relationships by adding an end date when that class ends?
I am talking about the relationship between a company (class) and an individual (student) in the join table, not the current "employer" field on the individual record.
Ideally, i would like to globally import end dates but can't do that without the relationship key. Is there a way to create a profile listing all current relationships of an organization where I can manually set end dates for students in a editable spreadsheet/profile format? I have many students assigned to classes that have ended and want to globally end those relationships without having to go to mySQL.
In other words, I need to create a listing of all the "active" relationships of an organization so I can easily edit start and end dates without a pop-up form.