One of the things one notices when building a Sharepoint app is that the "relation" and "navigation" between lists is not as comfortable as one would like, at the moment there is only a "upwards" navigation when a lookup field is set in a list. MS Access for examples allows one to navigate/drill down.
Suppose a simple CRM with these lists: Sales Staff, Accounts, Customers, Leads, Contacts, Opportunities, Orders, Quotations
So, one would like to see wander from an item Sales Staff to each and every related item
This would have the following benefits:
- Easier Navigation
- Better "Classification" of related items
- Related items would be an effective "Functional Tagging System"