The main form shows the
[选择]
many
one
side of the relationship and the subform shows the
[选择]
one
many
side of the relationship.

Question

The main form shows the 
[选择]
many
one
 side of the relationship and the subform shows the 
[选择]
one
many
 side of the relationship.

BlackTom AI · Accepted Answer

The question is about the structure of a one-to-many relationship between a main form and a subform.

In a typical relational data entry scenario, the main form represents the 'one' side of the relationship, where each record in the main form corresponds to a single instance of the 'one' side. The subform, which is used to enter related records, represents the 'many' side, allowing multiple related records to be associated with that single main form record.

Therefore:
- For the first dropdown, the correct selection is 'one' because the main form shows the one side of the relationship.
- For the second dropdown, the correct selection is 'many' because the subform shows the many side of the relationship.

Common misconceptions to avoid:
- Selecting 'many' for the main form would imply that the main form holds multiple related records per parent, which is not how one-to-many data entry is typically structured.
- Selecting 'one' for the subform would suggest that the subform can only contain a single related record, defeating the purpose of the subform in linking multiple related records.

In summary, the intended pairing is: main form = one, subform = many, reflecting the classic one-to-many relationship.

ACS19E1 - Microsoft Access 2019 Level 1 Module 11 Quiz

The main form shows the [选择] many one side of the relationship and the subform shows the [选择] one many side of the relationship.

查看解析

登录即可查看完整答案

类似问题

Once you added the tables to build a relationship, you then [选择] converted dragged right-clicked the relevant field from one table to the relevant field in the other table.

What is the purpose of the relationship feature in a table?

4 . What is the relationship between employees and managers?

Below is an entity-relationship diagram for a relational database: Which best describes the relationship between customers and sales?

In the figure shown below, which of the following business rules would apply?

When creating relationships between tables in Access, the two cardinality types used by the software are and .

In a consumer society, many adults channel creativity into buying things

Economic stress and unpredictable times have resulted in a booming industry for self-help products

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单