I'm having a problem with a grid when using a technique which has worked in many other instances:

My RecordSource is cMyTable. I have set

SET RELATION TO siteid INTO cSiteTable IN cMyTable

and I have a column who's controlsource is cSiteTable.name

When I bring up the form, all the values appearing in this column are the same (the value from the first record in cSiteTable). It's as if I had not set a relation.

When I then focus on the grid by tabbing to it, the values in this column refresh to be what I expected in the first place.

Is the SET RELATION irrelevant until I actually focus on the grid?

Thanks