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