来料检验单的单据体针对不同的检验项目都有不良原因，同时单据工具栏上也有不良原因录入。当然这两处的不良原因不尽相同。但有些客户处的是同一个，又不想录两遍，那就来个简单点的方法吧
select * from ICClassTableInfo where FClassTypeID = '1001000' and FPage = 2 --查询来料检验单相关字段
select * from ICClassTableInfo where FClassTypeID = '1002650' and FPage = 2 --查询不良记录相关字段
select * from ICClassLinkEntry where FSourClassTypeID = 1001000 and FDestClassTypeID = 1002650 --查询来料检验单和不良记录选单关联明细
INSERT INTO ICClassLinkEntry (FSourClassTypeID,FDestClassTypeID,FSourPage,FSourFKey,FDestPage,FDestFKey) VALUES ('1001000','1002650','2','FDisPassReasonID','2','FQualityID')--在该明细表中插入不良原因直间的选单关联明细
INSERT INTO ICClassLinkEntry (FSourClassTypeID,FDestClassTypeID,FSourPage,FSourFKey,FDestPage,FDestFKey) VALUES ('1001000','1002650','2','FBadQty','2','FDefectAuxQty') ---在该明细表中插入缺陷数和取样不良数量（严重）的选单关联明细