Re: Unique row in table field

[Joe D'Souza]

No. Even the table field qualification cannot be written such that it
displays only unique records.

You could achieve this, by customizing your form in such a way that while
inserting or updating that form, if the record is found to be duplicate, set
a flag that recognizes it as a duplicate. So only the first record has this
flag cleared..

The other way would be to step slightly outside of the ARS, and create a
underlying database view that displays unique information, and build a table
field pointing to that view..

While the first method has its advantage of being pure ARS, it would be
slightly more expensive in the sense that there will be a query every time
there is a insert or update operation to the table. The second being a query
only at the time the table needs to be displayed will be a relatively
inexpensive method..

Hope this helps..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Anuj DUA
  Sent: Thursday, September 16, 2010 5:32 AM
  To: arslist@ARSLIST.ORG
  Subject: Unique row in table field


  **
  Hello,



  Is there any property in table field to show only unique records?





  With Regards,

  Anuj Dua

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Unique row in table field

[Rod Harris]

Hi Anuj,

Have you considered using the tree view of a table field? That allows
you to group like rows together. It supports much of the functionality
found in ordinary list based table fields.

Rod Harris

On 16 September 2010 17:31, Anuj DUA  wrote:
> **
>
> Hello,
>
>
>
> Is there any property in table field to show only unique records?
>
>
>
>
>
> With Regards,
>
> Anuj Dua
>
>
>
> _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"