Hi Donal,there is a way to add JScript in the view designer, as your system accounts all start with #, you might be able to write something to exclude the system accounts?
please refer to this article for more information.
It may be a path worth exploring.
Hi Jordi,I believe what you are looking for is slightly different to what Donal is asking? We had a similar situation as you were we needed to implement associated record lookups, the below post should help you specifically the example for Country and City.https://carldesouza.com/filtering-lookup-fields-in-dynamics-365/
If you've found this thread useful, dive deeper into User Group community content by role