I am self taught.
I have 3 layers on my map: Retailer, Producer and Processor. Each business in each of these categories has a unique identifier, their license number.
I have a CSV file with a list of all sales between Processor and retailer. The problem is that for every transaction there is a new line in the CSV file.
So if A processor sold to 15 retailers then each sale relationship has a line (including the unique license number for the processor) so when I relate this table only to the processor layer it only adds the first sale. I want to be able to show all retailers that the particular processor sold too.
The next request is is there a way to, once the above is completed, to select a processor on the map and have all of the retailers sold to show up and no other retailers?