I have a table 'A' with Primary Key on 'ID' column. I have some data inside, however there is no record with ID = 1.

I have a table 'B' with AID marked as Foreign Key from table 'A'.

If I try to add new record in B i get:
DB Browser for SQLite
Error adding record:
CHECK constraint failed: B (INSERT INTO B (AID) VALUES (1, ...);)