Import and Relate Fields Through Script

Discussion created by BillR_1 on May 15, 2016
Latest reply on May 17, 2016 by bigtom

I have an Excel file of store locations with addresses, as well as the related state senator and assemblymember whose district includes each particular store. Every store is entered twice in the spreadsheet (once for senate, once for assembly) so the spreadsheet can be sorted a variety of ways. I know how to import the stores with their address info, and I can repeat the import for legislators, but how do I write a script to make the relationship? There are multiple stores in each senate and assembly district.


Thanks in advance.