I am trying to create a report where I have as primary table the Change order I need to show all the C.o. made for that particular Subcontract and then show the invoice related to the same subcontract pulling the info from A/P Invoices table. 

i tried [SELECT acpinv.invnum FROM acpinv WHERE acpinv.vndnum={subcon.vndnum}] 

but is not working.

Please help me!

thanks