We are looking to show a sub grid of Accounts based on matching two Option Set fields in that Account Form.
We are a property company with buyers and sellers.
We have two fields in each Account both using the same Option Set list - Property type
One option set is there to define the Property that account has - ie 1 bedroom
The second is there to define the Property the account is looking for ie 2 bedroom
We want the subgrid to display Buyers for the Account who is the seller based on the criteria of their property matching the criteria of the Buyer property.
We already define Buyers and Sellers separately with different option sets.
Any help much appreciated in how to achieve this as I'm at a loss.
