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.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
