I'm in DB Browser for SQLite and I don't see any way to set a PK:FK relationship. Can it do that?
thanks - dave
When adding/editing the table Scroll right or enlarge the screen and then double-click the respective row underneath the Foreign Key heading. Select the Table and the column that the FK is to be comprised of.