i cant figure out how im going to do this.....

im writing a dvd rental system....ive put all the items im going to rent out in a listview, then i threw it in a loop so that it can go into my hireout table. (which is working according to plan).

now im stuck coz the client im writing this for wants a record of how much money is spent. so i have the fields:
amountdue, amountpaid, changegiven, paymentmethod.

but if i put this fields in the hireout table and put them in the loop as well....then it will come up more than once. meaning if i rent out 5 dvds, then the amountdue, amountpaid, changegiven, paymentmethod will be saved 5 times.

then i though about creating another table to save these in, but how will i then link the hireout table to this table? or maybe someone can help me find a better solution.

reason client im writing system for wants these fields saved is coz he wants to know over a period of lets say 4 months how much money the client who is renting has spent with him. and upgrade them to silver, platinum whatever status.