I think the direct answer is No, not just with table fields alone. Depending on how goofy (technical term) you wanted to get, you could put a filter on the table's underlying form, fire it on submit/modify, and push the field that you want to use as the Distinct value to a new form that only held the distinct values (update existing on match, create new if no match). Then build your table on that new form. Not necessarily pretty, but it keeps it all in Remedy.
Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "L. J. Head" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 05/24/2007 12:14 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Select Distinct in Table Field? Yea....that's why I stated 'without leaving remedy'...I know how to do the DB View...I was looking for the ability without doing that -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rogerio Sent: Thursday, May 24, 2007 12:49 PM To: arslist@ARSLIST.ORG Subject: RES: Select Distinct in Table Field? You could build a SQL view and then a View Form on it. Then you could build a table field over that view form. HTH, Rogerio Bronzoni Aguiar [EMAIL PROTECTED] -----Mensagem original----- De: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Em nome de Kemes, Lisa Enviada em: quinta-feira, 24 de maio de 2007 15:38 Para: arslist@ARSLIST.ORG Assunto: Re: Select Distinct in Table Field? The only way you can do this is by a SQL call within the Active Link or Filter. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head Sent: Thursday, May 24, 2007 2:33 PM To: arslist@ARSLIST.ORG Subject: Select Distinct in Table Field? Is it possible to do a Distinct selection within a table field without leaving remedy? ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"