added another subquery to the search, to include supplier name rather than code