For an app with existing data you could use an escalation to push the first
time distiction checks.
This process would work for a join form as long as the Unique Identifier was
contained in one of the forms and then that field included in the join form.
Build your table from the join form to include the unique qualifier check and
you should be good.
Dave
Scott Parrish <[EMAIL PROTECTED]> wrote:
**
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}
st1\:*{behavior:url(#default#ieooui) } 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
---------------------------------
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, May 24, 2007 4: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!
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___
Shape Yahoo! in your own image. Join our Network Research Panel
today!http://us.rd.yahoo.com/evt=48517/*http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7
hot CTA = Join our Network Research Panel
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
