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:[email protected]]on Behalf Of Anuj DUA Sent: Thursday, September 16, 2010 5:32 AM To: [email protected] 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"
