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?