I’m creating a table of people, and I want to record a table of productions, with the amount each person contributed to that production. So we have a table of share splits; each production earns an amount of shares referenced by a splitid, and each split id covers a number of rows saying how many shares each person gets.

I’m creating a table of people, and I want to record a table of productions, with the amount each person contributed to that production. So we have a table of share splits; each production earns an amount of shares referenced by a splitid, and each split id covers a number of rows saying how many shares each person gets.

This is (hopefully) a dumb question, but it’s been an age since I last did any SQL and my supposedly simple one-to-many relationship is erroring in a way that I don’t understand.

Colleague, I have small database and C++ program with sqlite3 library.
There are several table with connection by Foreign key: