Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find by form on invoice

Status
Not open for further replies.

kerberos

MIS
Feb 3, 2001
4
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top