How would I create a 'current' attribute that relates to a collection? I have created a collection object called 'scheduled date', related to the change object. It can hold several dates but i would like a query to show only the current, or most recent, date. This seems to be how the 'current assignee' works, but i'm not sure how to replicate this.
Current Assignee as an attribute branch of the tree in query designer is hard coded in the application. If you are using 7.3 take a look at the calculation in there which shows Current Analyst. That grabs the latest entry off the assignment collection and zaps it into a handy string field. You could do the same with your collection.