Hs,
I think you may have overlooked what can be done with a SQL Select - create a view that joins both of these tables and you can then use the print when condition.
Andrew
>I change my system for DOS FP2.6 TO VFP5.0
>
>I use hand code to print INVOICE, at DOS verson. There have many special case to a ITEM record, sometime it need to print out its ASSORTMENT record from another database. I can handle it step by step.
>
>But i really don't know how to do it in the REPORT FORM (VFP5.0). I had try many ways in those day. But no result.
>
>I have try to use the "Print When" to call a sub_program to do something as below :
>*****
>set device to print
>@ prow()+1,00 say "hahaha"
>set device to screen
>return
>*****
>But the "hahaha" haven't print out. How to do????
>
>
>Can you send a invoice or quotation REPORT FORM to me, for my study.
>^_^...sorry, i really need your help!!!