表新手的关系！ [英] Table Relationships for a Newbie!
本文介绍了表新手的关系！的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
您好。我遇到了一个让我感到沮丧的问题。最糟糕的是，我知道答案很简单！
我创建了两个表（见图）。一个包含车辆的主要细节，另一个包含为该车辆执行的服务程序列表。
Hello. I have encountered a problem that has frustrated me for going on two days now. And the worst part is that I KNOW the answer is so simple!
I have created two tables (see image). One contains the vehicles main details, and the other the list of service procedures that have been performed for that vehicle.
推荐答案
请发布在该按钮上运行的代码。
Please post the code that runs on that button click.
展开 | 选择 | Wrap | 行号
哦，你正在使用宏。我不会使用宏，但我可以告诉你我将在VBA代码中做些什么。我打开表单并在OpenArgs参数中传递CUA＃。然后，在表单的on load事件中，我将使用CUA＃填充外键字段。
Oh, you''re using a macro. I don''t use macros but I can tell you what I would do in VBA code. I would open the form and pass the CUA# in the OpenArgs parameter. Then, in the on load event of the form, I would populate the foreign key field with that CUA#.
这篇关于表新手的关系！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
