Ah....here we get into some more specifics that I didn't present before.... I have Table A with unique records. Table B has a one to many relationship to Table A I have a Join between A and B...lets call it C...I need my table to be based off of C for qualification purposes...but I only want to show a single record from A as opposed to the multiple records that you find in the Join
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 24, 2007 2: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?gamek ey=monopolyherenow> Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"