我想要做的是利用MASTERFIELD來達到兩個TABLE中的某一欄位來篩選我要的幾筆資料，就是客戶欄位，但是我一新增資料就會產生這樣的錯誤，我再重新設定我的INDEX就可以ㄌ可以請問一下這是為什麼 也順便幫我想一下解決方法...拜託ㄌ

Hi，answer，您好！ 小弟的實做如下: 主表用:ADOConnection，ADOTable，Datasurce，DBLookupComboBox元件，其中的DBLookupComboBox元件主要是設置了ListSource，ListField，KeyField屬性，以和主表相連。 而副表用:ADOTable,Datasource,DBGrid元件，主要設置了ADOTable的MasterSource屬性。 我試著類比出Index Out of Data，但是小弟實在愚昧，一直未成功，結合您在http://delphi.ktop.com.tw/topic.php?TOPIC_ID=54460提出的問題，小弟覺得我們是否應該以Index來展開討論啊，建議不妨把注意力集中到那裏去，我們大家一起探討！謝謝 ================================= <>人生在勤，不索何獲 <>業精於勤荒於嬉，行成於思毀於隨 <>臨淵羡魚不如退而結網

------
人生在勤，不索何获？

通常會發生Index out of date的原因是系統曾經不正常的關機或是資料庫存取發生問題。 你可以參考 http://www.gtcl.com.hk/cfaq.htm#1.3 或參考對岸整理的一份說明Deliphi技巧集A.chm來源出處對不起我忘了內有一段 Q & A - Database "index out of date" error Applies to These Versions Categories Version Numbers Not Applicable Database Related -------------------------------------------------------------------------------- I am working on a Delphi program in which I am inserting information into a database table by running a student's ID card through a scanner. I was testing my program and at some point in time when I had a student scan his card, I received an error message saying, "Index is out of date. Table:c:\kathy\student.DB". Student.DB is the name of my database table and I have no idea what this error means. I have looked everywhere in my Delphi books for some help on this problem, so I hope you can help me. Don't fret. The "Index out of date" message can mean a couple of things: You copied your table into the directory, but didn't bring its index file along to overwrite the one that's there. Your index is corrupt. In any case, do the following: Open up your table in Database Desktop. Restructure it. Define/Rebuild all your indexes. Save the file. This is the only way to fix a bad index. 請參考！ Andy Chang

------
Andy Chang