I am testing an SQLite database with two linked tables one to many relationship. The many table has an Id field set integer, unique, autoincrement. In the Data Editor when I add test records to the many table, the autoincrement Id field does not automatically increment. I have to enter the value of this field manually.
Is this normal behavior in the Data Editor or have I missed something.