在append后使用,分割多个子表纪录:
adodc1.recordsource="shape {select 序号,物质名,分子式 from 物质表}" & _
"as parentcmd append({select 序号,温度,气化热 " & _
"from [气体性质表]} as childcmd relate 序号 to 序号)" & _
"as childcmd气体表,({seelct xxx......} relate) as xxx,......"
adodc1.recordsource="shape {select 序号,物质名,分子式 from 物质表}" & _
"as parentcmd append({select 序号,温度,气化热 " & _
"from [气体性质表]} as childcmd relate 序号 to 序号)" & _
"as childcmd气体表,({seelct xxx......} relate) as xxx,......"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货