Related records should show

[Ashif Malayil]

I have created 3 Modules, State, District, City. So in Each State i have mapped respective Districts and City, same for District respective City. So in another module i have created relationship of all 3 modules. First i have selected one of the State and updated it. Then i want to select District, but at this time it is showing whole Districts, instead of this i want to see only corresponded State - Districts. Same for City also, Once District is updated. It should show corresponded City - District. To make this possible what all are the relationship should i use. Can anyone guide?

[eymen-elkum]

You need to create 2 custom views for city & district.

This task is not easy, if you have some coding skills you may achieve it.

See this doc to learn how to do custom fields views:

https://docs.espocrm.com/development/custom-views/#field-views

You need every view to listen for the change event of its parent view, here is an example:

this.listenTo(this.model, 'change:state', () => {
    // update current options based on the value of parent
});