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
How can you have an Organization not mentioned in the Individuals table?  That would only happen if the Organization had no Individuals, right?"

Yes, sort of. Our dataset is not complete. So there are some organizations for which we have simply not recorded the individuals involved. Similarly, in the individuals table, some of the individuals do not yet have organizations (or, in fact, do not represent an organization at all).

Thank you for the advice about key fields.