根据另一个表填充数据 [英] Populate data based on another table
问题描述
我很抱歉，如果有人之前发过这个问题，但我已经找了它，我找不到它。
我在Orders数据库上使用Access 2003 ，为了简单起见：
我有两个表，一个是TBLCustomers，另一个是TBLOrderHeader。两者都有字段AgentId，我创建了一个表单，我想在客户更新时，从TBLCustomers获取AgentId值并将其保存到TBLOrderHeader。
我想要的原因使这个重复价值，是因为在任何给定时间代理人都可以改变，但我想保留历史记录，关于谁是什么订单的代理人。
我对VBA和SQL的了解是基本的。
提前感谢您的帮助
I am sorry if somebody posted this question before, but I already looked for it and I was not lucky to find it.
I am working with Access 2003 on an Orders Database, to make it simple:
I have two tables, one is TBLCustomers and the other is TBLOrderHeader. Both have the field AgentId, I created a form and I want at the moment the customer is updated, to take the AgentId Value from TBLCustomers and save it to TBLOrderHeader.
The reason I want to have this "duplicate" value, is because at any giving time the agent can change, but I want to keep the history on who was the agent for what order.
My knowledge on VBA and SQL is basic.
Thanks in advance for your help
推荐答案
这两个表的元数据是什么？
以下是如何发布表MetaData的示例：
表名= tblBookings
What is the metadata of these two tables?
Here is an example of how to post table MetaData :
Table Name=tblBookings
什么是元数据这两个表的ata？
这是一个如何发布表元数据的例子：
表名= tblBookings
对于大多数专家来说，这有点太长了。这是表格结构的准确表示。
表名= TBLCustomers
That was a little too long for most experts to trawl through. Is this an accurate representation of the table structures.
Table Name=TBLCustomers
这篇关于根据另一个表填充数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
