把这段代码改一下:
2.thisform.grid1.column1.text1.DBLCLICK代码:
with thisform.grid2
.recordsource=''
select distinct a.* from zhucheng a,cailiao b where alltrim(a.hpdm)==alltrim(thisform.grid1.column1.text1.value) into dbf zhucelsb
.recordsource='zhucelsb'
go top
.setfocus
.refresh
endwith
********************************
2.thisform.COMBO1.INTERACTIVECHANGE代码:
with thisform.grid2
.recordsource=''
select distinct a.* from zhucheng a,cailiao b where alltrim(a.hpdm)==alltrim(thisform.COMBO1.text) into dbf zhucelsb
.recordsource='zhucelsb'
go top
.setfocus
.refresh
endwith
1、在表单的load事件中输入:
PUBLIC C_BM
SELECT 2
USE zhucheng
SELECT 1
USE cailiao
2、在表单的Combo1的Valid事件中输入:
SELECT 1
C_BM=ALLTRIM(This.Value)
SELECT 2
SET FILTER TO ALLTRIM(hpdm)==C_BM
GO TOP
thisform.grid1.SetFocus
thisform.grid1.refresh
这会你可说明白了,你现在这两个库中的CAILIAO.CLDM与ZHUCHENG.HPDM是关联的.你加上以下代码看下:
1.THISFORM.LOAD代码:
select * from zhucheng into dbf zhucelsb where recno()<1
2.thisform.grid1.column1.text1.DBLCLICK代码:
with thisform.grid2
.recordsource=''
select distinct a.* from zhucheng a,cailiao b where alltrim(a.hpdm)==alltrim(thisform.grid1.column1.text1.value) into dbf zhucelsb
.recordsource='zhucelsb'
go top
.setfocus
.refresh
endwith
3.COMMAND1.CLICK &&增加一行
with thisform.grid2
.recordsource=''
if used('zhucelsb')
select zhucelsb
else
use zhucelsb
endif
append blank
.recordsource='zhucelsb'
go top
.setfocus
.refresh
endwith
&&其它的需要你把ZHUCELSB增加的数据记录到原来的表ZHUCHENG就要你加代码了,当然以上的代码也可以用SET DELETE ON实现,但这语句不提倡用,我也没写这代码.