If I have 10 locations, I have 10 Promoted links. Each promoted links contain all information about that particular location (i.e. Promoted link of Location 1, contains all information about location 1).
All locations contains 20 columns as Col1, Col2, ...Col20
In location 1: Col1 has100 options, Col2 has 2000 options, and so on
In location 2: Col1 has 23 options, Col2 has 77 options and so on
Now I want to have a query for these prompted links. If "Location 1" is chosen, then only the options of Location 1 must show shows up for the Columns.