:)...ya beat me to the punch _____
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Parrish Sent: Thursday, May 24, 2007 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Select Distinct in Table Field? ** A very nice solution if you are able to think that far ahead when designing your application. This will work if the distinct data you want to display is coming from a regular form, but not (at least, many times not) if it is coming from a join form. Often, it is the use of the join that is causing the need for the ability to display distinct data in the first place. Scott Parrish IT Prophets, LLC (770) 653-5203 http://www.itprophets.com <http://www.itprophets.com/> _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 24, 2007 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: Select Distinct in Table Field? ** There is a process which requires a little workflow but it will work. Create a Unique Identifier field on your form as a checkbox with a value of "Checked" or any other value you want. Create a filter on that executes on submit which will perform a Push Fields and set the checkbox if no other records match your distict field. Example: Action: Push Fields Push Field If: 'FIELD' = $FIELD$ If No Requests Match: Take no Action If Any Requests Match: Modify First Matching Request Fields Unique Identifier = checked Use the Unique Identifier Checkbox as a qualifier for your table. HTH, Dave Fincher "L. J. Head" <[EMAIL PROTECTED]> wrote: 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" _____ Boardwalk for $500? In 2007? Ha! Play <http://us.rd.yahoo.com/evt=48223/*http:/get.games.yahoo.com/proddesc?gameke y=monopolyherenow> Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"