StrataFrame Forum

Search field list and result

http://forum.strataframe.net/Topic8645.aspx

By Chan - 5/1/2007

Hi,

I have tables as below

PurchaseInvoice -> PurchaseInvoiceDetails -> Items
                       -> Vendors

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

By StrataFrame Team - 5/2/2007

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.