OK, so I've managed to give myself a nice headache and nothing much else :)
What I'm trying to do is create a simple database tracking a model railway collection. From this, I have four basic item types (Loco, wagon, coach, other), for each of which I've created a table.
I've also created a...