How do I display a reference field based on the related list from another reference field

[Stacy1]

I have created a many to many table between locations (cmn_location) and a configuration item we call Branch Office (u_cmdb_ci_branch_office).

Each location can have more than 1 branch associated with it in the related lists.

I have a catalog request where I have the user select the location.

I then want to display only those branches that are in the related list associated to that location.

I have tried 2 dozen different ways very unsuccessfully.

Can someone please tell me exactly what I need to do.

Thank you in advance for your help.

Regards,

Stacy

[Stacy1]

S

Sorry my picture did not attach, let me try here.

[Stacy1]

It's not a field name.   It's a related list.   It's not a field on the form.   It is many to many relationship.

[Abhinay Erra]

Sorry, I am confused here. Is this on your personal developer instance? I can look into it

[Abhinay Erra]

Got you.

[Abhinay Erra]

What is the relationship between the locations and branch office tables?