I am trying to display a certain view in a lookup depending on what value is in another entity lookup.
In "Case Entity", I have a lookup field called "Worktype"
I have an Entity called "Link from Worktype to Time Activity", this has 2 lookup fields in there for many to many relationship, from Time Activity and Worktype.
I have an entity/activity called Time Spent that a user create a new record everytime they work on a case.
I have views that returns all Time Activity, that is linked to "Worktype" of the "Case"
In Time Spent Entity, I have a mapping to "Case", and a lookup field to Time Activity. I there anyway, if so how, to only display (when they click the lookup field) the "Time Activity View" needed for the "Worktype" of the "Case" without the user having to manually dropdown the list and select.
I hope the above makes sense.
Any help would be very much appreciated.