I have an Editable Grid A based on "Crossing Group"-entity which has a lookup to Contract Entity. There are currently two records CR1 and CR2 that have a relation to a specific Contract
I have an another Editable Grid B including a "Crossing Group" lookup field.
Is it possible in JavaScript to dynamically limit the Crossing Group lookup field options to CR1 and CR2. Something like:
select [CrossingGroup] where [CrossingGroup].ContractId = XXXX