Drew, Running a distinct query would be the fastest way of retrieving that data and create an csv file from that result or a view form that you can report out to a arx file.. Reload that data after that. So you do not end up with duplicates, try and identify what may cause a record to be duplicate and check that with work-flow..
Joe ________________________________ From: Drew Shuller <d...@io.com> To: arslist@ARSLIST.ORG Sent: Wed, July 21, 2010 3:34:55 PM Subject: Self-Join Hello everyone. I've got a form with many many duplicate records in it, at least in one field. Is there a way to use a self-join form that will show only the distinct records? What fields would I use for the join? Or would it use a qualification? I may end up running a DISTINCT query on the db and reloading the form with that data. Thanks in advance! -- Drew Soto Cano Honduras _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
