>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?
A sidenote: Only use alltrim() when you really need it, meaning almost never!