>>Hi Nicholas,
>>
>>>BTW I just checked. One table in this system has 59 indexes.
>>
>>The project I'm working on had close to 100 in one table before we started optimizing them away. <g> The number of indexed affected the time it took to run the form, because every tag results in a 4 KB block that needs to be read when the table is opened for the first time.
>
>
>Yes
>
>if my budget was open there would be plenty of work. Unfortunately its not and I've seen several examples of my correcting something at point A causing something to fall off at point B. :-(
http://ndragan.com/pv/captain.html