Hi i am trying to do a transaction. It's basically were a customer makes a booking of a particular ablum(dvd or cd). In my database i have a table called Transaction with the following colomun names: Trasaction ID , MemberID, AlbumID , issueDate and ReturnDate.
Here is were the problem is as i have the AlbumID linked to another table called: Albums . Here in the Album table is the following column names: AlbumID, AlbumName, Quantity_Available and AlbumType(DVD or CD). The transaction made , when a customer books a particular album e.g: DVD = e.g: JamesBond , then in the database the quantity of that DVD is say for e.g: 30. It should then be 29 after it has been booked.
How do i do this when i have a form that does transactions and link it by updating the album table (the coloum Quantity available)