# Re: 关于dbcombo&dblist的连结

Posted by jealin on July 24, 1997 at 21:35:38:

In Reply to: Re: 关于dbcombo&dblist的连结 posted by 小吴 on July 23, 1997 at 20:52:25:

: 当 user 在 DBCombo 中选了一个项目，你可以在 msrdc1.Resultset!栏位 中得知 user 是选那一个。然后你必须为 msrdc2 产生一个新的 SQL
: "SELECT fields FROM table WHERE field=msrdc1!栏位"，设定给 msrdc2 之后，再 Refresh msrdc2 就可以了。

我太笨拙了
对于你所写的"msrdc1.Resultset!栏位",可否举一个例子呢!?
(我有两个table:1.viewtab(tab_enid(英文),tab_chid(中文)),
2.viewfld(tab_enid,fld_enid(英文),fld_chid(中文)))
我的属性栏是这样设的:
msrdc1.sql="select tab_chid from viewtab"
msrdc2.sql="select tab_enid,fld_chid from viewfld"
dbcombo1.rowsource=msrdc1
dbcombo1.listfield=tab_chid
dblist1.rowsource=msrdc2
dblist1.listfield=fld_chid
dblist1.datasource=msrdc1
dblist1.datafield=tab_enid
你所写的"SELECT fields FROM table WHERE field=msrdc1!栏位"
我这样写:"select tab_enid,fld_chid from viewfld where
viewfld.tab_enid=viewtab_enid"
这样设对吗?(还有关于resultset的相关设定)
谢谢!!

Follow Ups:

- Re: 关于dbcombo&dblist的连结 小吴 18:16:47 7/28/97 (0)