Darshana, When you walk the table and append the current record to your "delimited string" simply also see if the value your about to add to the "delimited string" is already a part of the "delimited string". If it is, then do NOT add it again.
-- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 12/14/06, Darshana Jivan [MTN Network Solutions] <[EMAIL PROTECTED]> wrote:
** Hi, I have a View form "Contacts" that reads from an underlying table from another schema in the database. I have a Table Field on a form "Notify" that displays the Contact information. I then loop through the table to get the sms/email values and set it as a delimited string. This is where I am having a problem; the contact can be associated to many branches and therefore the contact information will be duplicated many times. I need to be able to do a Distinct or and extract to be able to get the distinctive value, or else the contact would be notified one to many times depending on how many branches they are associated with.
<snip>
I need to get a distinct email and sms value to send a notification to the relevant contacts. Any suggestions? Regards, Darshana Jivan MTN Network Solutions
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"