>i have been getting this problem more and more often these days. i hope someone can help!
>as an example:
>2 tables in the Data Environment. both have indexes (regular) on PoNum and both have those set as the 'order'. i drag PoNum from the the file where it appears only once and drop it onto the index in the file that has the 'many'. the line appears and indicates that the relationship has been established. on the form, i have a single column grid in which the 'many' will appear. so, what theoretically should happen (and in the past has heppened) is that as the record pointer in the file with the single instance of PoNum is moved, only the records matching the PoNum in the file with the 'many' should appear in the grid - right? no - everything in the file with 'many' appear in the grid. if i remove the relationship in the DE and use the 'builder' on the the grid and get the relationship together that way, it all works correctly - only once though! if i close that form and come back to it with the same PoNum - the grid shows all records of everything again. the only way i can get the results
>i want is setting a filter and that isn't the way i want to go due to screen delays when the files are huge.
>if this has driven you mad already and you have hit paydirt - please help!!
>tia - john
grid.refresh (after the drop)