For some reason when I sorta a field inside a report, all the dates for related fields with predecessors. It's silly because sorta only changes the view not the actual dates in those fields. In addition, in the form, the date is actually changed to the sort date. Can someone tell me why?
Complete Date for Project Alpha is 12-5-15 with priority of 1
Complete Date for Project Beta is 12-10-15 with priority of 2
Complete Date for Project Delta is 12-15-15 with priority of 3
Predecessor logic set up so forecast completion is 5 days after previous project
If I do a sort of a-z on the report level, all dates of Beta and Delta is now also
12-5-15 and if I click into them and go to the form, it also shows 12-5-15 now. Really confused.