I have a requirement of creating a custom table which 3 fields location type - Choice field with branch and department, Name(string) and Country (string). I have imported the data to the table. And all the three fields are used in the catalog item one is reference field and the other two would be either reference/list collectors. Could you please help me on this.
Catalog item variables - Location(Country) , branch and department
Based on Country selected, the branch and department should be visible (there are 100's of different branch and departments for each country).
Using this custom table as extended table for dl_matcher table.
Any suggestions? How to approach this?
