Ok, so I wrote a small python script that should work. The script should be able to handle a few points really quickly, but will be slower than needed if your very large numbers of input points. Since your said it will only be one at a time, this should be fine.
I included two ways of selected your related tables (manually and automatically). Remove the method you choose not to use. You will also need to make sure your key field already exists in all your related tables.
import arcview
import arcpy
workDir="C:\\path\\to\\data\\TESTGeodatabase.gdb"
pointsFC="MCCOG_Complaint.DBO.complaint"
keyField="complaintKey"
#Manually select related tables:
relatedTables=["MCCOG_Complaint.DBO.complaintProblem","MCCOG_Complaint.DBO.complaintWorkOrder","MCCOG_Complaint.DBO.complaintContractor"]
#Automatically select related tables:
arcpy.env.workspace=workDir
relatedTables=arcpy.ListTables("MCCOG_Complaint.DBO.complaint*") #all table that begin with 'MCCOG_Complaint.DBO.complaint'
#Copy rows to related tables:
with arcpy.da.SearchCursor(workDir+"\\"+pointsFC,[keyField]) as inRows:
for inRow in inRows:
for relatedTable in relatedTables:
with arcpy.da.InsertCursor(workDir+"\\"+relatedTable,[keyField]) as outRows:
outRows.insertRow(inRow)
print("Complete!")Let me know how it goes!
