naw...not obvious. I have lets say a common set of criteria and then two different 'specific' criteria. Situation One requires pulling only from A...situation B requires pulling from the Join C...I didn't want to have multiple tables...what I have ended up doing was setting up my table field with the Advanced criteria. In situation A I am pulling from Form A...in satiation B I am pulling from Join C...and toggling it via data instead of a distinct qualification. As always...there are multiple ways to skin this cat...
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad K Esser Sent: Friday, May 25, 2007 11:43 AM To: [email protected] Subject: Re: Select Distinct in Table Field? ** How many fields are in your join criteria? Could some Display only fields on form A, populated on GetEntry suffice? Also, now I'm curious what your situation is... If you're only displaying data from A, then what is on B that is relevant to the qualification, but not relevant to the presentation of the data (the user)? Additionally, any workflow based off the user selection of C shouldn't employ data from B, since that could vary (and the user wouldn't know why). Hopefully that makes sense. Its Friday, so there's probably an obvious situation that I'm not thinking of, but I am curious. Thanks, 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)" <[email protected]> 05/24/2007 03:38 PM Please respond to [email protected] To [email protected] cc Subject Re: Select Distinct in Table Field? ** 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: [email protected] 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! <http://us.rd.yahoo.com/evt=48223/*http://get.games.yahoo.com/proddesc?gamek ey=monopolyherenow> Play 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___ ***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.*** __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
