Here is a complicated problem:
I have a grid in a form which the RecordSource is an Alias, this alias has a relation to another table just to be able to display the description of an ID code field of the original table in one column of the grid, the original alias is filtered on a particular field. By some other means (other form opened by a command button) I change the contents of the original table, then I return to the original grid and the user meves to the top or bottom (with the Page Up/page Down key), or moves with the scroll bar to the top, suddently the column having the other table descriptions messes up, showing the same description in all rows. this gets corrected after I do a form refresh but only after that strange thing happens, if I do the refresh before it won't prevent from this to happen. It seems that the relation is broken for a while due to the filtered condition. I have optimistic table buffering on the grid alias
Did anybody understand my problem? any suggestions?