Re: Dynamic Queries followup

2004-08-25 Thread SGreen
By Jove! I think he's got it! BTW - Rhino, that was an EXCELLENT response. Stuart, I believe you have seen the light. What you figured out, thanks to Rhino and your own intuition, is basically how to normalize your data. Normalization is critical to database performance, scalability, and st

Re: Dynamic Queries followup

2004-08-23 Thread Stuart Felenstein
Thanks again for a wonderful detailed response. The part that was still bothering me was the multiple-same-category fields. I get locked into this thinking and well, it's difficult to let go. Then I tried something on a table that had MemID, Doc1, Doc2, Doc3 I had put Doc1 in a few hours earli