I’m building a solution for a client that may have around 80 K records… was thinking of breaking it up into multiple bases given that there’s a 50K record limit.
However, they need to be able to search across the bases at the same time.
I was thinking I could achieve this through a custom app that would allow them to do this search and return results from multiple bases.
Has anyone tried this? Any suggestions on how best to do this?