@L_ B_ Laun sorry for never replying I never got a notification that you had replied. If you are still looking at this you will need to make a database view

 

Assuming this is on the Crisis Event record, you would build a database view that joins the sn_recovery_event_asset table (which would be where you would say a location is impacted) to the sn_bia_dependency table and joining via Asset name and Depends on field and filtered where the element definition is location. Then you will be able to dot walk to the BIA fields via the impacted dependency group and then to the BIA.

 

You can then make a scripted relationship that then filters this database view for the impacted locations for the crisis events. This can then be added as a related list on the crisis form

 

Hopefully that helps!