>trying to create a database with 2.6 tables. I'm able to put them in the container, but then if I try to change the 'main' file's index to 'Primary', I get "Uniqueness of Index IndexName is violated". I can't set up the relationships. The only way it will work is if I delete all the records. But when I do that, (obviously I'm going to need the data) and try to append from a copy to add the records back in, it stops at about a third of the way through and gives me the same uniqueness of index error. What am I doing wrong?
The field you are creating the primary key from is not unique. Run the following SQL:
SELECT fldname, COUNT(fldname) AS Count FROM table GROUP BY fldname INTO CURSOR lvCounts
SELECT * FROM lvCounts WHERE Count > 1 INTO CURSOR lvDupes
where fldname is the field you are trying to set a primary key on and table is the FP 2.6 table. Browse the lvDupes cursor and you will see which values are repeated.
HTH.
Oct 31 = Dec 25