One of the strengths of Lotus Notes is that it is fundamentally a database, with bullet proof synchronisation.
One of the downfalls of Lotus Notes is that it is fundamentally a database with an aggressive hatred of its users.
Here is a classic example. To create a custom searches, you are presented with this drop-down list of the available fields you can search on.
Look at the size of the scroll handle! There are literally hundreds (thousands?) of fields to select from. Good luck getting the right one.