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
Ah, I think I see - thank you. So, to clarify, I should upload the records into their separate tables so they get their record IDs, export again, and then map each record in the join table spreadsheet to its record ID by using VLOOKUP?

I am new to all this. Do you happen to know how I can use excel to automatically format my data into separate records.
i.e. instead of:
Individual 1: Org 1, Org 2

Change to
Individual 1: Org 1
Individual 1: Org 2