ContributionsMost RecentMost LikesSolutionsMass upload to a specific table while leveraging fields from related tables.I have a list of new records i would like to upload to a specific table. My problem is there are two fields in this spreadsheet that pull from related tables. In my spreadsheet i intend to use for the upload i have the key field identifier from each other those other tables but cannot figure how to upload the data. For example: i am uploading a bulk of new orders with order related fields. However, one field is an address that comes from a different table (identified in the upload spreadsheet by the key field in the "address" table) and a "department" field that also identifies the department key field. Each of those two fields ultimately bring in a variety of other information in reports so i need to establish that relationship during the upload. How do i make that relationship during a mass import? Thanks for any help you can provide!