Currently, when we create a table, regardless of it having alternative views, any lookup will:
- Always refer to the master table
- Always open the layout associated with the master table
- Always use the display column set in the master table
However, it would extremely useful if it were possible to lookup from a view with the following functionality:
- Always refer to the view (not the underlying master table)
- Always open the layout associated with the view
- Allow a different display column for the view
- Always use the display column for the view
There are quite a few use cases where the same underlying data (held in the master table) needs to filtered by using a view… but also to use a different visual representation better suited to the specific view (i.e. the layout for the view, and a different display column)