You asked for it!

Structure for table: K:\BA_CLIENTS.DBF
Number of data records: 197092
Date of last update: 1998/04/06
Code Page: 1252
Field Field Name Type Width Dec Index Collate Nulls
1 CLE Integer 4 Asc GENERAL No
2 OFFERCD Character 2 No
3 TOTUSERACC Character 3 No
4 STANDDOM Character 2 No
5 CDNREQNOWE Character 1 No
6 CDNREQWITH Character 1 No
7 ORDERONLIN Character 1 No
8 WEBTRAININ Character 1 No
9 BELLPROVWE Character 1 No
10 AIBNWEBFN Character 18 No
11 AIBNWEBLN Character 18 No
12 AIBNWEBPHO Character 10 No
13 AIBNWEBEXT Character 4 No
14 AIBNWEBEMA Character 50 No
15 NOWEBHOSTR Character 1 No
16 NOWEBHOSTB Character 1 No
17 IPADDRCURR Character 15 No
18 TSFEXISTCD Character 1 No
19 CURDN Character 50 No
20 CURAIDEDIC Character 1 No
21 CURISP Character 15 No
22 CURWMFN Character 18 No
23 CURWMLN Character 18 No
24 CURWMPHONE Character 10 No
25 CURWMEXT Character 4 No
26 CURWMEMAIL Character 50 No
27 PREFCUSTD1 Character 24 No
28 PREFCUSTD2 Character 24 No
29 PREFCUSTD3 Character 24 No
30 DESCCIE Character 150 No
31 CUSTCIENAM Character 60 No
32 DDSTCIE Character 4 No
33 ORGTYPECD Character 4 No
34 BTN Character 10 Asc GENERAL No
35 ADMSALNAME Character 3 No
36 ADMFN Character 18 No
37 ADMLN Character 18 No
38 ADMTITLE Character 15 No
39 SHIPADDR1 Character 30 No
40 SHIPADDR2 Character 30 No
41 SHIPADDR3 Character 30 No
42 SHIPCITY Character 30 No
43 SHIPPROV Character 2 No
44 SHIPPC Character 7 No
45 ADMPHONE Character 10 No
46 ADMEXT Character 4 No
47 ADMFAX Character 10 No
48 ADMCUREMAI Character 50 No
49 TECHADM Character 1 No
50 TECHSALNAM Character 3 No
51 TECHFN Character 18 No
52 TECHLN Character 18 No
53 TECHTITLE Character 15 No
54 TECHADDR1 Character 30 No
55 TECHADDR2 Character 30 No
56 TECHCITY Character 30 No
57 TECHPROV Character 2 No
58 TECHPC Character 7 No
59 TECHPHONE Character 10 No
60 TECHEXT Character 4 No
61 TECHFAX Character 10 No
62 TECHCUREMA Character 50 No
63 BILLADM Character 1 No
64 BILLSALNAM Character 3 No
65 BILLFN Character 18 No
66 BILLLN Character 18 No
67 BILLTITLE Character 15 No
68 BILLADDR1 Character 30 No
69 BILLADDR2 Character 30 No
70 BILLCITY Character 30 No
71 BILLPROV Character 2 No
72 BILLPC Character 7 No
73 BILLPHONE Character 10 No
74 BILLEXT Character 4 No
75 BILLFAX Character 10 No
76 BILLCUREMA Character 50 No
77 LANGPREF Character 1 No
78 GSTEX Character 1 No
79 GSTEXNB Character 20 No
80 PSTEX Character 1 No
81 PSTEXNB Character 20 No
82 QSTEX Character 1 No
83 QSTEXNB Character 20 No
84 DUEDATE Character 6 No
85 NOTES Character 150 No
86 SALEREPID Character 5 Asc GENERAL No
87 SALESREPOR Character 10 No
88 NBEMAILADD Character 5 No
89 PRODCD1 Character 4 No
90 QTY1 Character 3 No
91 PRODCD2 Character 4 No
92 QTY2 Character 3 No
93 NOFAX Character 10 No
94 ENVFAXA Character 40 No
95 AVANTOPT Character 1 Asc GENERAL No
96 AOCONTRAT Character 1 No
97 AOCNBAN Character 1 No
98 CONTACTNAM Character 36 No
99 NOTESODEMA Character 254 No
100 OVER150LD Character 1 No
101 PICDSTAT Character 1 No
102 WINBACK Character 1 No
103 RESPCODE Character 2 No
104 SOURCEMEDI Character 1 No
105 ACCESLOCAL Character 1 No
106 CUSTID Character 10 No
107 CALLDATE Character 10 Asc GENERAL No
108 CALLTIME Character 5 No
109 PARPOSTE Character 1 No
110 EMAIL Character 50 No
111 CONTRATSIG Logical 1 Asc GENERAL No
112 AOFAXELE DateTime 8 No
113 CONTRATFAX DateTime 8 No
** Total ** 2011

>I have been unable to duplicate the problem...can you post the exact source table structure and list of all table indexes?