问题描述
我正在建立我的表格之间的关系。我不知道如果我这样做是最有效的方式或不。似乎在我的头上工作。
我有一个简单的帐户设置,只包括电子邮件和时间戳的订单号码。
我想要的访问是自动插入这个信息在不同的表,所以用户不必在每个表单上重新输入。
这里是我现在的关系表:
这样,电子邮件帐户和订单号在表之间匹配,以保持信息链接。我已经在保存
和 openForm
的表单上添加了一个按钮,但我找不到一个选项,插入数据。
EDIT
尝试规范化表。仍然不知道如何我可以链接到一起。
这是一个开始:
使用以下字段创建帐户表:id,name,email(say)
有订单表,包含id,accountId,orderAmount
将Order.accountId作为与Account.id关联的外键
p>
选择帐户。,订单。从帐户内部连接Order. Account.id = Order.accountId
I'm working on building relationships between my tables. I am not sure if I am doing this the most efficient way or not. Seems to work in my head.
What I have is a simple account set-up that consists of just an email and a time-stamped order number.
What I would like Access to do is automatically insert this information across different tables so the user doesn't have to retype them over on every form.
Here is the relationship table I have now:
This way the email account and order number match across the tables for keeping the information linked. I have added a button on the forms that save
and openForm
but I can't find an option that will auto-insert data.
EDIT
I have taken advice and trying to Normalize the tables. Still not sure how I can link them together. How can I group that entire order with that one customer?
Here is a start:
Make Account table with fields: id, name, email (say)
Have Order table with fields: id, accountId, orderAmount (say)
Make Order.accountId a foreign key linked to Account.id
When you query do something like
select Account., Order. from Account inner join Order on Account.id = Order.accountId
这篇关于如何将帐户表与MS Access 2013中的订单表相链接?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!