Hi,
I have three entities (eg: Entity A, Entity B, Entity C) which are having lookup field of another entity(Entity D). Now my requirement is, In the Entity A main form i want to filter the lookup field(entity D) to show only the records, which are not associated with any of these three entity records(Entity A, Entity B, Entity C). Is this possible?
If Yes, how?
Below table with sample data will explain more.
| Entity A(Fields) |
Entity B(Fields) |
Entity C(Fields) |
Entity D(Fields) |
| Name (single line text) |
Name (single line text) |
Name (single line text) |
Name (single line text) |
| Item (lookup of Entity D) |
Item (lookup of Entity D) |
Item (lookup of Entity D) |
Value (Option Set) |
Now in the forms of Entity A or B or C, the lookup field should show only the records that are not associated with any of these three(Entity A, Entity B, Entity C) entity records.
