I have managed to get a filter query to work with help from Tutorial odb’s etc. I want to copy all the data from tblRecInfo to tbl_filter_RecInfo, and when I select ‘copy’, then ‘paste’, on tblRecInfo, I select Data and Defintion , then change the PK ID from integer to a Yes/No Boolean, then ‘Create’ but only the first 2 records are copied.
I get an error message box up saying :
Violation of unique constraint SYS_PK_102: duplicate value(s) for column(s) “ID1” in statement [INSERT INTO “tbl_Filter_RecInfo” ( “ID1”,“BuyDate”,“Item”,“Quantity”,“SupplierName”,“Cost”) VALUES ( ?,?,?,?,?,?)]
In the actual tutorials, only the Definition is copied, and data was added afterwards. I would rather not do it that way if it were possible. Would it mean more work or using a macro to achieve this.
If no records were copied I could understand it better, as it would prompt me to look or find out why.
I know it says ‘duplicate value(s)’, but I don’t know where to look for that. Unless it means that the duplicates are Yes and No???