I would like a sub report to pullup a vendor's matching ID to a material called for in the main report. I've gotten this far..

{Vendor_material.Material_Owner}={?PM-MC_RFQ_TTX.sMaterial} and
{RFQ_Vendor.Send_To_Address}={?PM-MC_RFQ_TTX.Send_TO_Address}

(the send_to_address fields are available in both the original report and one of the tables in the subreport)

I get double IDs. If I use only the top sentence, I get all ID's. I'd like to use 'where' instead of 'and' but Crystal doesn't like it.

Can someone direct me? I am really new at this.
thanks