Filter reference field based on another reference field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 01:36 AM - edited 11-18-2024 01:38 AM
Greetings,
There is a requirement to filter a reference field(Table A: Entity Type) based on other reference field(Table B: Entity Name) in the Table C(c_entity_type, c_entity_name). The relationship between the 2 fields are maintained in Table B.
1. I tried adding c_entity_type under dependent field in c_entity_name variable which gives me blank.
2. I also tried using javascript:'entity_type='+current.variables.c_entity_type under advanced reference qualifier of c_entity_name variable which gives me all the values instead of filtered ones.
Please suggest on the above requirement, if there is any change required or solution available.