一个组织可以有很多关系 [英] One organization can have many relationships

问题描述

您好。我有一个实体表，列出实体类型，实体名称等。我有一个关系表，它使用实体表中的ID和公司表中的ID。问题是实体表中的实体可以与该表中不在公司表中的另一个实体有关系。发生这种情况的原因是因为该实体不是公司而是各种管理结构。有关如何使这个工作运行视图和查看名称的任何想法？谢谢。

解决方案

它被称为连接表。

它允许建立多对多的关系。

你应该看一下这篇文章。

定义表关系

本文介绍如何在Microsoft Access数据库中定义关系。它包括以下主题：

？什么是表关系

？表关系的类型
$ b $b◦一对多关系 $ b $b◦多对多关系
$ b $b◦一对一关系


？如何定义表间关系
$ b $b◦如何定义一对多或一对一的关系
$ b $b◦如何定义多对多关系



？参照完整性

？级联更新和删除

？联接类型

@zmbd


也许我不清楚。实体表中的实体可以与实体表中的另一个实体具有关系，并且还可以与公司表中的公司建立关系。希望澄清一下。感谢并期待您的回复。

为什么不组合实体和公司表？如果两者之间的区别仅仅是描述性的，则无需将它们分开。

Hi. I have an entity table that lists entity type, entity name, etc. I have a relationship table that uses the ID from the entity table and the ID from the company table. Problem is an entity in the entity table can have a relationship with another entity in that table which is not in the company table. The reason that happens is because that entity is not a company but a governing structure of sorts. Any thoughts on how to make this work for running views and seeing names? Thanks.

解决方案

it''s called a join table.
it allows a many to many relationship to be established.
You should take a look at the follwing article.

Defining Table Relationships

This article describes how to define relationships in a Microsoft Access database. It includes the following topics:
?What Are Table Relationships
?Types of Table Relationships
◦One-To-Many Relationships
◦Many-To-Many Relationships
◦One-To-One Relationships


?How to Define Relationships Between Tables
◦How to Define a One-To-Many or One-To-One Relationships
◦How to Define a Many-To-Many Relationships


?Referential Integrity
?Cascading Updates and Deletes
?Join Types

@zmbd
Maybe I wasn''t clear. An entity in the Entity Table may have a relationship with another entity in the Entity Table and may also have a relationship with a company in the company table. Hope that clarifies. Thanks and looking forward to your response.

Why not combine the entity and company table? If the difference between the two is merely descriptive, there''s no need to separate them.

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