Hi,
I'm creating a library system and i have one table for the catalouge with all the book information.
One table to rent a book and one table to return a book.
There is an Available field on the catalouge table for each book to see whether the book is available or not.
When i rent a book i...