Free and Open Source Software

About once a year, I unsuccessfully quest for a FOSS replacement for Filemaker Pro. Specifically, I'm on the hunt for a solution that:

1. Lets me create a variety of graphical 'layouts' of fields positioned on a page to display different segments of the data.
2. Can search the data from those same layouts, by entering text into various fields (eg, 'Sanderson' in author, '< 1/1/2015' in date.

This is largely for personal sized datasets: I only need to handle small (several thousand entries, all just text based) data collections. Basically, small enough that it could in principle be handled using a Libreoffice Calc spreadsheet and applying filters - I'd just like something more friendly.

Several users will use my databases (locally, no need for online hosting). It will be rare that multiple users try to access it simultaneously, so its ok if only one person can open at a time. Macros and relational field structures would be a bonus but not necessary.

I've tried a bunch of solutions. The closest are:

1. Libreoffice Base. Layouts can't be used to both enter and search data. Creating new search queries is overly arduous.
2. Kexi. Similar to Base.
3. Symphytum. Great, except the search is much too limited (no field specific search)

Any other suggestions?