I have an External SQL Source that I have a shadow table of in FileMaker. That shadow table is great for viewing or editing the data, but as we know it is not indexable. Therefore it can't be used for value lists or finds (it's prohibitively slow to find on.) I want to come up with a good solution for being able to read and write from SQL and be able to find on it and use it in value lists.
So far the only idea I've come up with is to have a table that mimics the shadow table but has all of the data stored locally in FileMaker. I am then concerned with how to keep these two tables in sync as records are added, deleted or edited.
I know someone else out there has done this well. Any suggestions?