如图,主件品名显示为元件的品名了,怎么写才能让其显示主件的品名啊,望大仙赐教!
在SQL语句里把BOMMC替换成下面的SQL语句
(SELECT BOMMC.*,MB002 AS MB002C FROM $$BOMMC AS BOMMC LEFT JOIN $$INVMB as INVMB ON MC001=MB001) AS BOMMC
然後把主键品名的显示字段的SQL改成MB002C就可以了
(SELECT BOMMC.*,MB002 AS MB002C FROM $$BOMMC AS BOMMC LEFT JOIN $$INVMB as INVMB ON MC001=MB001) AS BOMMC
然後把主键品名的显示字段的SQL改成MB002C就可以了
温馨提示:答案为网友推荐,仅供参考