I have an object application which contains a related field: lender. My task object then has a related field lender that comes from the applcation object. In my list of tasks, i cannot sort by this field. Is there a way around this? Could I create a text 'lender' field, and use some sort of trigger to store the value in the tasks table, rather than having a related field type?
Yes, that can be a work around.
Matt,
Yes, Pavel is correct. You can used a trigger to write the value to a text field and then sort on that in your Views.
Hope this helps