Any one have a quick and dirty solution for searching a record but with different results?
For instance I have this record
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