I have 3 entities:
Inspections
Assets
Diffencies
1 Inspection record has 0 or more Assets records
1 Inspection record has 0 or more Diffencies
1 Diffency record has a lookup to 1 Asset
My functional goal is, that when I create a new Diffency, the Assets find control filters on the Assets which are set on the same Inspection record. At this moment I see all Assets. How to implement this?
When I click on the command bar button "+ New Defency" I see the screen below. When I click on the search button from column Asset, I expect only the Assets from the Inspection.