Hi Guys. I have a loan form where I loan items to people and place the info in a mysql db. I would like to be able to update that particular loan with comments say when I get some or all the items back on what date and quantity received. I would like to update that loan until all the items are received back at which time I can close out that loan. How can I construct this loan DB that will show the original loan and a history of all later transactions. As of now I have one table for the loan table which consists of a auto increment Primary and other fields such as date, item, name, email blah blah blah. Any suggestions would be great!!!
