Hi Nick,
I think I answered my own question. After checking my code, it came to me, I only had one table SELECTED (Policy). I didn't
>Have the Client table open (SELECTED). so it couldn't get the client information FirstName Last Name into the report.
> So what I did was add the Client table after the SELECT POLICY, CLIENT. The Code is as following.
>
>SELECT * FROM Policy, Client ;
>WHERE policy.group_code==lcGroupCode ;
>AND policy.ins_co_name==lcIns_co_name ;
>INTO CURSOR myReport
>
>IF RECCOUNT("myReport") > 0
>Select myReport
>Report Form PAYMENT1 PREVIEW
>ELSE
>?? CHR(7)
>WAIT WINDOW "MATCH NOT FOUND, TRY AGAIN" TIME 2 NOWAIT
>ENDIF
>USE IN myReport
>thisform.text1.value=""
>thisform.text2.value=""
>thisform.refresh()
>thisform.text1.setFocus()
>
Does this look right ? or is there a better way of doing this ?

Happy john