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?
My use case is I need to see if a certain entry in one table, exists in another (by matching a couple fields).I can't use a combined text because those are limited to a string of 150, and my string will be about 1500 entries, and i need to search through those 1500 specific entries to see if there is a match. I could use like 15 combined text fields and break it up but that sounds like too much work.
I could use a query but my query will need to parse 60k+ records and start eliminating.
------------------------------
Mike Tamoush
------------------------------