How to make the Reference fields dependent on catalog item form?

[Atik]

Hi All,

I am working on the catalog item where I have three fields Country, Company and Office Street(type - Reference fields on catalog item form) which I am referencing from the 'core company' table.

Table Form:

Catalog Form:

Here You can see on upper form I wanted populate the fields like company field dependent on Country field and Office Site field dependent on Company field 

On Table form there is option like dependent field but on catalog form how to achieve this..

Please anybody can help me with this??

Thanks,

Atik Bagwan

[Tai Vu · Accepted solution]

Hi @Atik 

You can set the reference qualifier of the Company variable, making it dependent on the Country variable.

I'm assuming that your Country variable is referencing to the Country [core_country] table.

The reference qualifier could be like below.

javascript: "country=" + current.variables.country.getDisplayValue();

You can do the same to the Office Site variable.

Cheers,

Tai Vu

[Atik]

Hi @Tai Vu ,

thanks for the help it is working can you help me with the office site also I am struggling with this from last week.

Actually now based on the company i have to show the office site

Thanks,

Atik Bagwan

[Tai Vu]

Hi @Atik 

Can you help to share the table that the Office Site is referencing, and how it is currently associated with the Company (via which field)?

Cheers,

Tai Vu

[Atik]

Hi @Tai Vu ,

For Office Site also I am referring the 'core_company' table only and i wanted to show the street field value in Office Site Variable

Thanks,

Atik Bagwan