Questions tagged [many-to-many]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5
votes
2answers
985 views

Many-to-many relationship and QGIS Forms

I have a PostgreSQL/PostGIS database with a base table (Pois_points) and two subtables which constitute a many-to-many relationship with the base table, as you can see on the picture below (click on ...
4
votes
1answer
95 views

Setting up and displaying many-to-many relationships with CartoDB

I have to display many-to-many relationships between offices and sub-offices for a client. Each office manages many sub-offices, each sub-office can be managed by many offices. The client is ...
5
votes
2answers
3k views

Using the Make Query Table for Querying a Many-to-Many relationship

I have two tables that I have connected via an attributed relationship class of the cardinality Many-to-Many. One is a table of water body (rivers) features and the other is a series of pollutants ...
4
votes
1answer
4k views

Using many-to-many join in ArcMap

I'm working in ArcMap 10 and can move around in R, though am not an expert. I have a shp file and an xlsx file. The shp file is 20,221 rows and includes a field GID (grid ID) which is not unique ...
4
votes
1answer
441 views

Accessing “many to many” relationship class using ArcGIS Identify?

I am trying to create a many to many relationship class in ArcGIS 10.0. When Identifying the features though, I don´t see the associated table values. Here is the Class schema: Destination Table ...
3
votes
1answer
2k views

How to add data to relationship table in ArcGIS 10.1 database design?

I have created 2 tables HORSE and VENDOR and a relationship table VENDOR_HORSE With the foreign key in Horse being the Primary key in VENDOR (VendorID) and the foreign key in VENDOR being the primary ...