Thank you for sample. I have tried modifying what you posted to my code but after i run it the fields don't get updated. I don't get no error. Any ideas on what i am doing wrong?
import arcpy
mainTbl = "C:/Temp/BP.gdb/TaxParcels"
joinTbl = "C:/Temp/BP.gdb/Permits"
fieldsToJoinList = ["AppSubmitted","PermitIssued","Classification"]
#Addfields
fields = [
("AppSubmitted","Date","","","","","NULLABLE","NON_REQUIRED",""),
("PermitIssued","Date","","","","","NULLABLE","NON_REQUIRED",""),
("PermitNum","Text","30","","","","NULLABLE","NON_REQUIRED",""),
("ParcelNum","Text","24","0","","","NULLABLE","NON_REQUIRED",""),
("Classification","Text","4000","","","","NULLABLE","NON_REQUIRED","")
]
for field in fields:
arcpy.AddField_management(*(mainTbl,) + field)
joinTblDict = {r[0]:r[1:] for r in arcpy.da.SearchCursor(joinTbl, ["PIN_Num"]+fieldsToJoinList)}
updateRows = arcpy.da.UpdateCursor(mainTbl, ["PIN_ID"] +fieldsToJoinList)
for updateRow in updateRows:
if updateRow[0] in joinTblDict:
updateRow[1] = joinTblDict[updateRow[0]][1]
updateRow[2] = joinTblDict[updateRow[0]][2]
updateRow[3] = joinTblDict[updateRow[0]][3]
updateRows.updateRow(updateRow)
del updateRow, updateRows