Forum Discussion

SamW's avatar
SamW
Qrew Cadet
7 years ago

Importing Data to Many-to-Many Relationships (populating related fields in join tables)

I have two tables - Individuals and Organizations. They are in a many-to-many relationship through a join table. This seems to work well. But I would like to upload my existing datasets to these...
Data import and export
Relationships
Tables and fields
SamW's avatar
SamW
Qrew Cadet
7 years ago
I see. They are separate sets of data, in that the Organizations table will contain organizations not mentioned in the Individuals table, and vice versa.

Are there any disadvantages to changing the key field in the parent tables to the Individual and Organization names, rather than  keeping it as the record ID?