THank you both for your help and advice. As I lack the experience and expertise to take this further, i'll stick to the way I am doing it now. At least it works:):)

Eventually, I want to convert the offline databse to sqlite again and merge various tables so they are full of data instead of links. First, I have a lot of learning to do!!!

Still, my little library book manager is beginning to look less useless than it was (ROFL)