Want empty cell if no find

[DarrenWard]

I have three tables, table one has a relation set to table two and table two has a relation set to table three.

On my form I have a grid, all but the last column set is to a field out of table one, the last column is populated by a field out of table three.

Most of the time the data in table one will not be in table two, so I presume table two and three should be at eof() but the last column in the grid is always populated with the same piece of data when I want it to be blank.

I hope this makes sence, if not let me know and I will try to explain again ;-)

Darren

GuiltyMaggot - The best rock band in the world!

 

[dbMark]

Could this be a refresh issue?
thread184-707377
thread184-691490
thread184-620908 mentions both .setfocus and .refresh()

 

[BPeisch]

I would say that this sounds like your relationship is not set properly. Are you doing this in code? If so, can you post the code you use to setup the relations?



-BP

http://www.peisch.com