如果只是文件中提到的问题,你可以在入网表的备注列设置这样的刷新公式:
if([使用状态]="报停","该用户费用缴至:"+text(FindText("报停","费用缴至","编号","=",[编号],-1))+";实际使用至:"+text(FindText("报停","日期","编号","=",[编号],-1))+";欠费"+text(-Int(-(YearFrac(FindText("报停","费用缴至","编号","=",[编号],-1),FindText("报停","日期","编号","=",[编号],-1))*12)))+"个月,合计欠款:"+text(-Int(-(YearFrac(FindText("报停","费用缴至","编号","=",[编号],-1),FindText("报停","日期","编号","=",[编号],-1))*12))*[金额]/12)+"元","")
然后在报停表的编号列操作公式中设置:SetCellText("入网",[入网!RelationRow],"使用状态","报停") And RecalcRow("入网",[入网!RelationRow])
应该注意的是,编号列不要使用输入掩码设置,否则一旦触动编号列,原有的数据会出错。