Hello!
I have two tables, say, Parent and Child. Child has a lookup column to the Parent table and in a Model Driven App, there's a Lookup View to help the user select a Parent record for a new Child record.
Ideally, I'd want to change the lookup view to first display (parent) records where the user is the owner of the (parent) record. Records where the user is not the owner should follow afterwards. But i don't think this is possible.
Is there someway i can sort by owner starting with the user?
Or a way i can add two lookup views, one filtering for owner, and the other non-filtered, and attach these views to the same field in the app?
Any help would be much appreciated!
