In the Group By of your view, can you not include all of the columns selected for the view?  List the VendorID first, then add the rest of the columns and you should get the results that you're looking for.

Hi,

I have tables as below

I need to allow user to search for vendorid. I created browsedialog which provides search field such as ItemCode, ItemName and VendorName which based on an user defined view (JOIN 4 tables above).

The search result may contains duplicated vendorid. Therefore, I need to add GROUP BY vendorid to my view. By doing this, I only can include vendorid in select column list. However, I need to provides other fields for searching in my browsedialog.

Any advice?

Thank you