mrwelborn62

I am new to Caspio and attempting to create my first application. I was attempting to import my data and ran into a problem with a table skipping records with the following message: The table contains unique fields with duplicate or blank values. These values were not imported The statement is an impossibility because my source data has a defined primary key. My source table is located in a SQL database and I exported it to a flat file for import into Caspio. The structure of the source table is shown below: CREATE TABLE FacilityAddresses ( FacilityAddressID UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL CONSTRAINT DF_FacilityAddresses_FacilityAddressID DEFAULT (NEWID()), FacilityID UNIQUEIDENTIFIER NOT NULL, AddressID UNIQUEIDENTIFIER NOT NULL, Priority INT NOT NULL, CONSTRAINT PK_FacilityAddresses PRIMARY KEY CLUSTERED (FacilityAddressID ASC) ON PRIMARY FacilityAddressID is a Primary Key and is not duplicated FacilityID is a foreign key to the Facilities table AddressID is a foreign key to the Addresses table There are duplicate FacilityIDs in the table. This is necessary as a facility may have more than one address. There are also duplicate AddressIDs in the table. This too is necessary as some facilities share an address. I don't know how the import tool is determining that there are duplicate values, There are three GUIDs in the table, but the combination of all three is unique. It must be seeing that there are duplicates in the columns individually, but if this is the case how can one ever create a table with foreign keys? Any help would be appreciated.