在Visual FoxPro中建立表与表的永久联系 如图,在visual foxpro中建立二维表
\u7b80\u8ff0\u5728visual foxpro\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u8868\u95f4\u4e00\u5bf9\u591a()1:n)\u5173\u8054\u7684\u6b65\u9aa41\u3002
\u5c06\u4e24\u4e2a\u8868\u52a0\u5230\u540c\u4e00\u4e2a\u6570\u636e\u5e93\u4e2d\u3002
2\u3002
\u201c\u4e00\u65b9\u201d\u7684\u8868\u6309\u5173\u952e\u5b57\u5efa\u7acb\u4e3b\u7d22\u5f15\u6216\u5019\u9009\u7d22\u5f15\uff0c\u201c\u591a\u65b9\u201d\u7684\u8868\u6309\u6b64\u5b57\u6bb5\u5efa\u7acb\u666e\u901a\u7d22\u5f15\u3002
3\u3002
\u6253\u5f00\u6570\u636e\u5e93\u8bbe\u8ba1\u5668\uff0c\u6309\u4f4f\u9f20\u6807\u5de6\u952e\uff0c\u4ece\u4e3b\u8868\u7684\u6b64\u7d22\u5f15\u5b57\u6bb5\u62d6\u52a8\u5230\u88ab\u5173\u8054\u8868\u7684\u6b64\u7d22\u5f15\u5b57\u6bb5\uff0c\u6b64\u65f6\u4f1a\u51fa\u73b0\u4e00\u6761\u9ed1\u7ebf\uff0c\u81f3\u6b64\uff0c\u4e00\u5bf9\u591a\u5173\u7cfb\u521b\u5efa\u5b8c\u6bd5\u3002
\u8f93\u5165\u5b8c\u6574\u6309\u786e\u5b9a
\u65e9\u547d\u4ee4\u7a97\u53e3\u6253 brow
\u663e\u793a\u8868\u5185\u5bb9, \u73b0\u5728\u4e3a\u6ca1\u6709\u8bb0\u5f55
\u6309\u83dc\u5355\u680f \u8868 \u6dfb\u52a0\u65b0\u7eaa\u5f55 4\u6b21
\u5728\u8868\u4e2d\u8f93\u5165\u8bb0\u5f55...
...\u5b8c\u6210
\u4e5f\u53ef\u4ee5\u7528\u547d\u4ee4\u4ee3\u7801\u6765\u5b8c\u6210
create table \u5458\u5de5\u8868 ( \u5458\u5de5\u7f16\u53f7 C(6) NOT NULL, \u59d3\u540d c(8) , \u6027\u522b C(2), \u5a5a\u5426 L(1), \u5de5\u4f5c\u65e5\u671f D(8), \u90e8\u95e8\u7f16\u53f7 C(2), \u5de5\u8d44\u7ea7\u522b N(2,0), \u8054\u7cfb\u7535\u8bdd C(11))
INSERT INTO \u5458\u5de5\u8868 (\u5458\u5de5\u7f16\u53f7,\u59d3\u540d, \u6027\u522b, \u5a5a\u5426, \u5de5\u4f5c\u65e5\u671f, \u90e8\u95e8\u7f16\u53f7, \u5de5\u8d44\u7ea7\u522b, \u8054\u7cfb\u7535\u8bdd) VALUE ("010101","\u9648\u80dc\u5229","\u7537",.t., "\u6559\u6388",{^1986-07-01},"01",5,"13907318988")
***insert into 4\u6b21
第二步:打开数据库设计器,用鼠标分别拖动主表中刚才索引了的字段到子表中的索引了的字段上(此时如出现一条或2条黑线说明成功)
扩展阅读:visual expression ... microsoft sql server ... visual basic ... visual processing ... visual studio ... visual fortran ... microsoft visual fox ... outlook ... visual foxpro视频教程 ...