I have a Customer table (cust.dbf) with 286 Records; I used the ComboBox builder to create a "ComboBox". I have an Invoice, Job, and Quote form that use the cust table as anyone would in an RDBMS, I use the combobox to retrieve the customer's ID from the cust table. I than store that value in the respective header file (InvHD.dbf, JobHD.dbf, etc.) which is linked to the cust.dbf file. Simple enough huh?
>
>OK this is were it gets strange, on my forms I have an ADD, and EDIT button. If the current record in any of the *HD.dbf files has the "custid" of "SWFT" (Which is Swift-Eckrich) and I hit the EDIT button I get an error like, "variable 'CLS' not found". If I'm on a record were the custid is something other than "SWFT" all works as it always has.
>
>I would suspect an index problem, right? So lets reindex all the tables used on these forms... Same thing still happens, Delete and recreate all indexes for the related tables... Same thing, Pack the tables... same thing. Scan the tables with FoxFix, no problems reported... same thing still happens. Start to think there has to be something wrong with the cust.dbf file itself, in someway, somehow. So I export all the data to a delimited text file, Import it into a low-end Database (Access J) export to an Excel 5.0 spreadsheet, and import back into Visual FoxPro 5.0 as Cust2.dbf and rename to Cust.dbf, after I remove, delete the old table. Guess what,
>calling Microsoft now, but realize I would probably get a better answer to my problem from the UT. Going to try one last thing, Add in a record to the cust.dbf table with the CustID of "SWFT", I still have "SWFT1" in the table. Go to the Job form… To utter dismay all seems to work as normal. Delete the record I just added, and pack. Go to a record in the Job form were the CustID is "SWFT1" hit edit, and Blam! Same darn error. Add the dummy "SWFT" record back into the Cust.dbf table and guess what… All seems to be fine again.
>
>So, if somebody has an explanation to my problem, I would surely enjoy your fix. But please try and make it sound technical so I don’t feel like a complete loser. J
>