I'm thinking that a join form might work. I'm going to check the documentation on inner and outer joins. Maybe join the view form to itself. Then use the join form in your table field.
James On Jul 16, 4:30 pm, Chintan Shah <[email protected]> wrote: > Hello, > > I have a table field that represents a view form. Now, I need to get only > unique rows in that table. > > The problem is for a particular ID(on view form) there could be multiple > email addresses and I want to get DISTINCT email in table field before > walking through it and extracting required infor. I dont see any option > available under "Table/Tree Property" for doing this. > > In a nutshell, here's scenario. > 1. View form pointing to an external DB that holds multiple email addresses > as separate rows for a particular ID(this ID is different from primary key of > table). > 2. A table field that queries this view form with qualification: $ID$='ID'. > 3. Now, this returns a result set that has multiple rows in it with column > name of NAME,EMAIL. > I can do table walk and get required information, but how do I > extract only unique rows? > > e.g. if result set is as below > ID NAME EMAIL SOME OTHER COLUMN > 1 A X Z > 1 B Y Z > 1 A X P > > how can I refine it to just A-X, B-Y? Regardless of value in SOME OTHER > COLUMN, I need to use only A-X,B-Y. > > Basically, I am looking for SQL equivalent of DISTINCT in Remedy that can be > used with Table Field qual. > > Any help is appreciated. > > Thanks > Chintan. > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
