Are all of the address fields in separate fields? If so you can create a match key to identify dupes with a script as such
Sort Records [ matchKey ; ASC ]
Go to record [first]
Set Variable [ $check ; matchKey ]
If [ $original = $check ]
Set Field [ dupeFlag ; 1 ]
Set Variable [ $original ; matchKey ]
Go to record [ next ; exit after last ]
This will populate a "dupeFlag" field with a value of one, so you can search and omit any dupeFlag = 1 records.
Your match key should be something like the address & zip stripped of spaces and puts it in the same case:
Lower ( filter( address1; "qazwsxedcrfvtgbyhnujmikolpQAZWSXEDCRFVTGBYHNUJMIKOLP0123456789 ) & left( zip ; 5 ) )
Missed a quote:
Lower ( filter( address1; "qazwsxedcrfvtgbyhnujmikolpQAZWSXEDCRFVTGBYHNUJMIKOLP0123456789" ) & left( zip ; 5 ) )
lol thanks. Filemaker needs a built in constant for that long alpha/number combo.
Soooo cool, Thank you much, worked GREAT!!!!