Hi All, I'm working on Remedy version 7.6.4, I have a table that reads from a regular form "VOD_SEET_Invoices", I need to select distinct values from this form through the qualification of the table. Is there a way or a function to do that? I need the qualification of the table to be equivalent to the following query:
Select DISTINCT Batch_No, Submitter From VOD_SEET_Invoices where Batch_No <>'NA' I tried to do that by creating a view in DB(reads from VOD_SEET_Invoices form) that has the above statement and creating a view form on it and then make the table reads from the view form instead of reading directly from "VOD_SEET_Invoices", but it didn't give me the result that I need because I faced the issue of selecting the Request ID of the view form. So I need a way to select the distinct values from "VOD_SEET_Invoices" through the table that reads from it, can I? Thanks in advance, Regards _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
