Filtering lookup values for a Editable list grid detail
I have developed an editable List Grid Detail (derived from BaseGridDetailV2). The detail is added to OrderProductPage.
The entity schema (table) for this detail has the following columns:
- OrderProductId (Lookup field from OrderProduct table)
- AssetId (Lookup field from custom asset table)
Assets are linked to Account. The detail is rendered properly however I want to filter the Asset field in the detail based on the opened Order's Account field (Detail screenshot attached). Currently it lists, all the records from the Asset table
Any Ideas on how this can be achieved?