InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumSun, 14 Jun 2026 10:18:59 GMT20http://forum.strataframe.net/FindPost8645.aspxHi,</P><P>I have tables as below</P><P>[quote]PurchaseInvoice -&gt; PurchaseInvoiceDetails -&gt; Items<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&gt; Vendors[/quote]</P><P>I need to allow user to search for vendorid. I created browsedialog which provides search field such as ItemCode, ItemName and&nbsp;VendorName which based on an user defined view (JOIN 4 tables above).</P><P>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.</P><P>Any advice?</P><P>Thank youWed, 02 May 2007 08:50:51 GMTChanhttp://forum.strataframe.net/FindPost8650.aspxIn the Group By of your view, can you not include all of the columns selected for the view?&nbsp; List the VendorID first, then add the rest of the columns and you should get the results that you're looking for.Wed, 02 May 2007 08:50:51 GMTStrataFrame Team