Good morning!  I imported multiple tables (CSV) which each already contained a unique primary ID.  It looks like a separate primary ID column was automatically created for each imported table (wdt_ID).  I'm not able to remove this column.  I'd like to use my existing ID column instead of wdt_ID, meaning I would need the existing ID column be auto increment etc.

I was able to link the tables using the foreign key feature.  This works well, however, if I add a new row, I have to manually enter the ID since it doesn't auto increment.

Is there a way to handle importing tables which already contain unique ID fields?  Or do I need to manually edit each wdt_ID to match the existing ID fields?

Thanks!!

Thanks for the reply!  I actually tried manually editing the wdt_ID column using the in-line edit function.  It allowed me to change it, but the changes automatically reversed when I tried to save.  Am I doing something wrong?  

I tried editing wdt_ID by clicking the column and choosing edit as well, but it does not appear in the edit form.

Maybe I'm missing something?

Thanks again for your help!

I believe I have figured it out.  I had to change the 'ID column for editing' setting to my existing ID field (instead of default of wdt_ID).  I am now able to edit wdt_ID field.  Once I have modified all 700+ entries to match my ID field, I will then change the setting back to wdt_ID and then delete my ID column.  I think this will get things working as expected.

Charlie