Is there simply no way to use a formula query on a table with 50k+ records? I've tried having a first query that would elimante all but a handful of options but I still get the 'will take too long error'.
Are queries just limited to small tables or is there a trick I am missing?
What queries have you tried so far? What is the field type you are trying to query?
The answer I always get from QB about formula queries is they don't work well for large data sets or tables with a large number of relationships.
There is a workaround that I used for a similar issue before formula queries were introduced. I created a text field to mirror the numeric field and created a combined text field using the mirror. It's not the most elegant solution, but it worked in the instance I used it.
I haven't tried a formula query on a Sync table, and you're right, that may be part of the issue.