I have a screen form with a number of pages within a Page Frame. All but one of the pages are fields for the primary table it's set up for. One of the pages is a grid for which I want to display records related to the current file and record from another file.

To do this, I set the record source type to SQL and set the SQL statement (record source) to somelike like "SELECT * FROM a_opcusp WHERE a_opcusp.custno = a_arcust.custno INTO CURSOR temp".

Nopw, I'm not sure if I need the INTO command, but regardless of this, I can only get this to work once -- when I enter the screen. When I skip through the primary file the records showing on the grid stay the same.

What am I doing wrong?
TIA!