Hi,
I am trying to create a simple library system that can issue and return loans. At the moment i have created a working system to issue loans. I have created a query that inserts the correct information into the borrowers table but for some reason it inserts the borrower ID into the first borrowers id field and also the correct one.
It is kind of hard to explain. I have attached the database. If you open it and open the form called loan, then select a borrower and cd and click issue. If you then go to the CDCopy table you will see that the borrower you selected appears twice on two different records, one correct and one not.
Is there something i have done wrong to my query or something.
Thanks in advanced.
I am trying to create a simple library system that can issue and return loans. At the moment i have created a working system to issue loans. I have created a query that inserts the correct information into the borrowers table but for some reason it inserts the borrower ID into the first borrowers id field and also the correct one.
It is kind of hard to explain. I have attached the database. If you open it and open the form called loan, then select a borrower and cd and click issue. If you then go to the CDCopy table you will see that the borrower you selected appears twice on two different records, one correct and one not.
Is there something i have done wrong to my query or something.
Thanks in advanced.
Last edited: