I've seen H0nza's talk about arachnophobia and have gone into our database and split it up and the speed has increased 5-fold almost instantly.
One thing that's breaking all over the place are user-specific global things. For example:
- Search box in top nav
- Date range for report search
In the past I had a "global" table and whenever a user connects to Filemaker it would create a new record for them and I'd store these sorts of things there. This allows users to (for instance) search for one thing on their phone and a different thing on their desktop.
All of these are fields that are editable, so they still need to exist as a field, and the search field specifically needs to appear in the top nav of every screen... argh... My brain is melting.
Do I add a "search" field in every table that has a layout with a top navigation (students, staff, dashboard, etc.) that's global? Is there some way to join back to global fields that won't throw a constant "someone else is editing this record" error message?