I have a FoxPro 2.5 table ,Customer.dbf. I have an Index "Customer.cdx" with 10 indexes in that file. When I attach the table to Access 2.0 it ask for an index file 'Customer.cdx' & it then asks for 'Select Unique Record Identifier'. It only displays 1 of the 10 indexes, Cust-New, and doesn't show the 9 other indexes.
I need one of the other index, 'Customer-I', found within that Index file 'Customer.cdx'.
What am I doing wrong? Why aren't all 10 indexes showing up in the selection box? How can I use that index?
Also I'm unable to make any changes to the index file, Customer.cdx, as it is used by other programs.