mcollinsamec,
That makes sense to me. I would assume that the new table would only have unique APN values? Could you help me with how to populate the new APN table with unique values? I've got the code below but I'm not sure how to point the sField to the feature class and field. Thanks for the help,
Brian
Static d As Object
Static i As Long
Dim iDup As Integer
Dim sField
sField = CMA_3_50ft_PARCELS[APN]
If (i = 0) Then
Set d = CreateObject("Scripting.Dictionary")
End If
If (d.Exists(CStr(sField))) Then
iDup = CMA_3_50ft_PARCELS[APN]
Else
d.Add CStr(sField), 1
iDup = 0
End If
i = i + 1