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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
1. every record on the join table will need to be a separate record on the excel upload.
2. You will need to prove the values for the fields [Related Individual] and the field [Related Organization]  on every excel record.

So typically you will need to dump the data from your app into excel to get at the Record ID#  ( and name) of the organizations and the individuals, and then use VLOOKUP (  ..., false) - to be sure of an exact match) in excel to get the record id of the Individuals and the Organizations coaxed into your import file.