Okay Travis,
We all were at somepoint, new to vfp. :-D

so, m.notesid is defined as a PUBLIC variable?

and, is this table 'reports', very big? more then 10000 records? Because set filter is fine for small tables, but the bigger tables it is better to do select... into cursor .

HTH
Beth

>I am pretty new to foxpro.
>
>The reason it stores the txtID is because that is how it finds all reports that are linked to this ID number.
>
>Inside the frmviewrptnts, I have the form's Refresh as:
>
>

>SELECT reports
>SET FILTER TO ALLTRIM(rptname) = ALLTRIM(m.notesid) (rptname is the first line in the grid that I want filled)
>thisform.grdReportNotes.Refresh
>

>
>Basically I am just looking at other databases to see how they were done and setting this up similarly. I am not sure if I am even on the right track here, but hopefully I am close. Any thoughts?