>>Using remote views, I have a module that keeps on giving me "Index does not accept Null." error. Looking at VFP documentation, it says that I have a primary index or candidate index that have null values. I already removed primary and candidate keys on all tables but the error still persists. Any ideas?
>
>What type of database is your remote view accessing (i.e. SQL Server)?

Thanks for you reply Cathi, but fortunately, I was able to debug it with pain. I found out that one combobox contains SQL statement that have WHERE clause evaluating logical value against fields which contain null values. See statement below:

Select items.itemdesc, itemcode From items Where Inlist(items.itemtype,invoiceitem.itemtype1,invoiceitem.itemtype2,invoiceitem.itemtype3) Into Cursor itemselect

invoiceitem.itemtype1,2,3 contain null values which causes the error.

Static data still reside in VFP database but transaction data in SQL Server.