No. I fixed nothing. I only pointed out the problem. You have bad data and my guess is that somewhere along the line someone did an update query incorrectly. So verses are pointing to the wrong chapter ID and thus the wrong book.
This does not fix anything because the problem is a data problem and not a table problem. Many of the book and chapter numbers are incorrect.
You somehow need to assign the correct book and chapters to a given verse. I am assuming you did not assign and collect these verses by hand and somewhere the keys just got messed up. Do you have the source data somewhere? If not you are going to have to do this by hand and that is 35K updates.
Even if you made a nice form to do the updates in groups, at most you would update10-100 versus at a time. Still a lot of work when you have 35k to update.
I did go ahead an modify the table to the simpler structure. I did some other fixes on the books form so you can pick a chapter and go to that chapter. But again you can leave it as is, but this is simpler for me. Simply move the Book_ID into the verses table.
In my design now the Verse has a BookID and a ChapterNumber.
