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.