>>Currently two tables,
>>One is Chooseit (Orderline in meaning!)
>>One is Item.
>>
>>In command Window, if:

>>1) Select * from item where itemkey = '1434-FG039AA'
>>Successful in browse!!
>>2) Select * from chooseit where itemkey = '1434-FG039AA'
>>Successful in browse but Sometime Fail!!!
>>but.......
>>3) Select * from chooseit inner join item ;
>>   on chooseit.itemkey = item.itemkey and ;
>>   item.itemkey = '1434-FG039AA'
>>return nothing!! ~'.'~
>>Even don't use join!
>>   Select * from chooseit, item ;
>>   Where chooseit.itemkey = item.itemkey and ;
>>   item.itemkey = '1434-FG039AA'
>>still nothing!! ~~~'_'~~~
>>
>>Of cos, both item and chooseit are bottom data as just add on it!!
>>And EVEN I close the tables and reopen again!
>>But Still Fail in Find???
>>Because It is impossible to Reindex or Sort the table everytime!!
>>I am Favour now... Unbrief to fail in find!!
>>Because the same order have some other itemkey and still add in
>>bottom but only this NOT FOUND!!! ~~~_~~~
>>What can I do????!!!!
>>
>>Of cos, Currently I have set:
>>SET ANSI OFF
>>SET EXACT OFF
>>
>>The more even worse case is: SQL 2) sometime fail.
>>But of cos, I can check over many times and even
>>pack the table!
>>
>>Currently the item table carry 2K and Chooseit carry 4.5K data only!
>>
>>What are the possible reason for fail in search?
>>RECNO for item is 1819 and RECNO for CHOOSEIT is 4442
>>is not the multiples of 255 or near it!! ~"."~
>>

>Field sizes and/or leading spaces ? Try with alltrim(), SQL 2 should never fail provided the record exist (if deleted on - not deleted). If still failing could you zip dbf, fpt and cdx (dbc of course) and mail them ?
>Cetin

Thanks, Finally I fix it but quite strange!!
Field sizes are same!! of cos, else other fields can't search!!
Alltrim() it already!! Even I type:
Use item
replace itemkey with alltrim(item) for .t.
use && of cos, option have set no buffering
and also does it in Chooseit!

Finally, I copy and replace the Chooseit.itemkey and success.
but previously, even I copy item.itemkey field to chooseit.itemkey but fail.
Possible reason(s) I wonder:
1) If add detailtable first but no match on Base lookup table,
the link will fail.
but if lookup table got the data first, the detailtable(many side)
can look it up.
2) Table Buffering Os. (5) may got trouble on update.
need check a lot!

~_~' Anyway, Thanks a lot, but sorry to email the data file as
security reason. if the data table is not item, but other less important,
i will ask my boss b4 sent.