Catalog Item Field reference and dependencies question

[Luiz Lucena]

Hello everyone, 

We have a catalog item with some fields that must be dependent on the previous selection. 
For example, Country field is a reference to core_country table, in that table, we have a dependent field called Project Type.

So, in the catalog item form, based on country selected, the list below for project template should refer to that Project Type on the Country table as the list below shows.

What is the best way to achieve this?

Thanks

[Brian Lancaster]

Are these variables lookup select boxes or reference? Also do you have the country listed multiple times in the core country table like on your spreadsheet?

[Luiz Lucena]

Hi Brian, 

Currently, it is Select Box and this is the closest I got (see image below).

For the second question, no, the core country table has unique country names, I've created a field for each country, called Project Type and depending on the country selected, it will present different values. See below.

The way it is now is presenting the entire list for Project Type field. See below, when Argentina is selected, the field below should present only the three items in the red square (like the image above.

Thanks in advance!

[Brian Lancaster]

I have been doing some testing in my PDI trying to use the reference qualifier on what would be the project template field. If I do something like name=Argentina it seems to work. However if I do name=current.variables.[country variable name]. However it does not seems to work. I think you may need to do a client script that calls and script include to repopulate the project template field.