复杂的关系 [英] Complex relationships

问题描述

   我的问题是与我的桌子有一个复杂的关系。我有一个人员，组织和地址表。它具有人员 - 地址关系，组织 - 地址关系和人员 - 组织关系。它有一对多
的关系。当我为每个人创建一个屏幕时，就会出现问题。一个人可以有很多地址。一个组织有很多地址。一个人可以有很多组织。例如，当我为Person表创建一个屏幕时，当我添加一个Person时，我
可以添加一个Address。当我添加地址时，值组织应该有一个值。由于它具有关系，因此需要有一个组织。有什么办法可以在不要求的情况下做到这一点吗？请帮我。我是
Lightswitch的新手。

最好的问候，

Nethan

解决方案

您可以将您的关系更改为"0..1到多个"如果你想要达到的目的不是要求组织是必需的，而不是"1到多"。

要修改你已经定义的关系：

1. 右键点击"行"行连接两个表，&选择"编辑关系"
2. 更改"一个"您可以在其中一个下拉列表中找到"Zero or One"。代替

Hi,

    My problem is having a complex relationship with my tables. I have a Person,Organization and Address tables. It has a Person-Address relationship,Organization-Address relationship and Person-Organization relationship. It has one-to-many relationship. When I create a screen for each, the problem arises. A Person could have a many Addresses. An Organization have many Address. A person could have many Organizations. For example, when I create a screen for Person table, when I add a Person, I can add an Address. When I add an Address, the value Organization should have a value. Because of the relationship that it has, it is required to have an Organization. Is there any way how can I do this without requiring it? Please help me. I'm a newbie in Lightswitch.

Best Regards,

Nethan

解决方案

You could change your relationship to be "0..1 to Many" instead of "1 to many", if all you want to achieve is not requiring that an Organization is required.

To modify a relationship that you've already defined:

1. Right-click the "line" that connects the two tables, & select "Edit Relationship"
2. Change the "One" that you'll find in one of the drop-downs to "Zero or One" instead

这篇关于复杂的关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！