将数据保存在2个表中 [英] Saving data in 2 tables

问题描述

我正在开发一个应用程序，我需要为Access数据库中不同表中的客户维护数据。我使用的字段：PartID，PartyName，接收金额日期，收到的金额等...



现在我想在其他表中保存相同的数据。我没有在我的表中创建任何主键或外键，PartyID是唯一的，一旦将ParttID分配给客户，它将永远不会被分配给其他方。

Hi,
I am developing an application which i need to maintain data for customers in different tables in Access database. The field i use: PartID, PartyName, Receiving Amount Date, Amount Received etc...

Now i want to save the same data in other table too. I don't make any primary or foreign key in my table, PartyID is unique, once the ParttID has been assigned to the customers it will never be assigned to other party as wel.

推荐答案

访问这里..



http://www.dreamincode.net/forums/topic/243706-how-to-save-data-in-两个不同的表格从vb6-form / [ ^ ]

visit here..

http://www.dreamincode.net/forums/topic/243706-how-to-save-data-in-two-different-tables-in-access-from-vb6-form/[^]

这篇关于将数据保存在2个表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！