Just a quick note on a problem I just worked around.
My grid fields wouldn’t sort. You click the gray heading bar, and they pretend they sort, but they don’t.
My main form data source was table A. I also had table B joining to A, table C joining to B, and table D joining to C. The grid datasource was A. Only the fields in the grid which were from datasource A would sort – and it took me a while to realize this, because I’m not really displaying fields from that table.
Once I figured out they must be on A to sort, I tried putting methods on table A to retrieve the data from B, C, D – but those didn’t sort either. Had to actually be fields. (Hm, I wonder if methods on the datasource would work?)
Not a big deal to me to add fields, since A is a temp table. But I can see this being problematic in other situations. I welcome input.