为多个相关表创建数据输入表单 [英] Creating Data Entry Forms for Multiple Related Tables

问题描述

我正在尝试创建一个数据输入表单，它复制了在使用
表中的下拉箭头时为一对多关系输入数据的难易程度。这允许用户在下一个相关表中输入数据，而不必一遍又一遍地键入主键或外键字段。

I am trying to create a form for data entry that replicates the ease of entering data for one-to-many relationships when using the drop-down arrow in a table. This allows a user to enter data in the next related table without having to type the primary or foreign key field over and over.

例如，如果我有一个表连接到的假期链接到Destination表的Month表（All表示一对多关系）。我想制作数据输入表单，允许我输入Vacation'name'键字段和其他数据，然后
能够将数据添加到Month表而不必重复键入关键字段的相同值'name'。

For example, if I had a table for Vacation linked to a Month table that is linked to a Destination table (All with one to many relationships). I would want to make data entry form that allows me to input the Vacation 'name' key field and other data and then be able to add data to the Month table without having to repeatedly type the same value of the key field 'name'.

我想创建一个包含子表单的数据输入表单，这些表单将在输入记录时自动填充指定的键字段在每个表中。我一直在尝试使用
master 和 child 字段来启用此功能但没有成功。所以我的想法是创建一个包含宏的按钮。有没有人建议怎么做？

I would like to make a data entry form with sub forms that will auto-populate the designated key fields when entering records in each table. I've been trying to use the master and child field to enable this functionality with no success. So my thought is to create a button that contains Macros. Does anyone have a recommendation on how to do this?

推荐答案

基于您的描述，我会将您的问题转移到MSDN论坛进行访问

Based on your description, I'll move your question to the MSDN forum for Access

https://social.msdn.microsoft.com/Forums/en-US/home?forum=accessdev

我们建议发帖的原因适当的是，您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

这篇关于为多个相关表创建数据输入表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！