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
Jim Nelson
Newbury Park, CA