I have the standard invoice form with inv_hdr and inv_items subform. I would like to perform a query by form and allow the user to search for a keyword in the sold item description field which is in the invoice line items subform. I can get the query to work but it displays only the line items whose description matches the query. What I would like to have happen is for the query to return only the records that have a match of description but to also the other items that were sold on that invoice as well.
Thanks
Thanks