I have a sub form, which is pay information, which is entered via a parent form, I am wanting to show all of the past pay for the emplyee that is being entered, I have a commen key which is the employee's name, how am I able to sort and show the data only beloning to that emplyee in the sub form.

Done this however now I am unable to save data to the subfrom from the parent form, using the following code

var vSub as String
var vRec as Int

     vSub = "Pay History"
     vRec = @FormNewRecord(vSub)       // Create the new subrecord

     FormFieldValue(vSub, "le2", vRec, le1)
     FormFieldValue(vSub, "Ord Hrs", vRec, Hours)
//      FormFieldValue(vSub, "Alpha Key", vRec, Employee)
//      FormFieldValue(vSub, "Ord Hrs", vRec, Hours)
//      FormFieldValue(vSub, "Ord Hrs", vRec, Hours)
//      FormFieldValue(vSub, "Ord Hrs", vRec, Hours)
//      FormFieldValue(vSub, "Ord Hrs", vRec, Hours)
//      FormFieldValue(vSub, "Ord Hrs", vRec, Hours)

     FormCommit(vSub)       // Save the new subrecord
     FormCommit("")             // Save the parent record
     If @FormViewType(vSub) = 0
     {
           FormResultSetCurrentPosition(vSub, vRec)
     }