Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Grid in a Relations with Set Filter
Hi,
I have 2 tables, named "parent" and "child".
Next, I have a grid whose rowsource is "parent", as type alais.
I need to be able to set a filter on BOTH the parent and child.
Any gotchas with this. Any specifis steps in setting this up?
Thanks,
Stanley
PS...
Views and sqls are out of the question as they are way too slow, because of the 700,000+ records and they all must available. Indexes are not persistant in views and takes too long to build on the fly (about 25 seconds). It takes longer for sql because it must sort it as it create its cursor. I've tried all types rushmore stuff and 30-50 seconds is as good as it gets... Not to mention the whole machine slows to a crawl after its built, and responce is terrible.
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- filter grid set
- Participating Experts
- 4
- Solution Grade
- B
Posted on 2005-11-21 at 14:42:18ID: 26225927
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.