There are situations in which we have a regular table containing for example all services and a linking table, linking services to for example objects.
When I want to add a service to a record in a third table that already contains an object then I would like to filter on these objects and only be able to select services that are linked to that object.
Now this is very easy by making this linking table the lookup table for the service. Sometimes we also use views as a lookup, where the view enables us to filter on multiple complex conditions for services to select from.
Now when a service suddenly doesn't comply to these conditions and would drop out of the view then the display of the service would be empty. Afterall the service isn't present in the lookup table anymore. However I would very much like this service to still be displayed correctly.
I would like to name one lookup (the view) to select a service from and one lookup (the regular table containing all services) to use as the source for the display-value. In this case the service can disappear from the view, but still be visible in my application, possibly with a tooltip or color signalling that there is something that needs attention.