> However, the records DON'T appear in date order in the grid.

I would be tempted to use a parameterised view rather than a relation in a case like this. The parameter can be the employee number (I think that's what you are using to relate) and in the view desginer insure the order tab is set orderd by the field you want. So you have the relation but you can have the records in any order you like.