AnsweredAssumed Answered

Multi criteria finds

Question asked by Jason_Farnsworth on Nov 15, 2011
Latest reply on Nov 16, 2011 by Jason_Farnsworth

Any one have a quick and dirty solution for searching a record but with different results?

 

For instance I have this record

 

11-14-2011 5-54-41 PM.png

I am trying to create a report based on the main order number, then by which Vendors show up on the line items for the report. I would like a report for each Vendor listed in the Order with all the lineitems they are listed for the current order. Currenty I have and perhap wrongly done 5 seperate fields for the vendor name all looking back to the main Vendor table.

 

I am not sure of the best way to go about it, and any direction would be greatly appriciated.

 

Thanks in advance

 

Jason

Outcomes