Hoi!
Basically, I've got a form:

And as you can see, in order to select the right loan (Or even see the loan details, Nursery name, book name, author etc) you have to look in to the loan table and then remember the Loan_ID
GO back into the delete loan table and select the right loan_ID from the combo box...
most people will probably forget before they even get to the delete_loan form :')
So, somehow i'd like to insert some kind of 'sub' table at the bottom of my form..
which will list all the loans from the loan table..
I've tried sub report/sub form.. but it kept updating every time i chose a record in the combobox..(Lets say i selected #5 in my combobox, the table would then only show #5)
I don't want to do anything with it, just show the current loans
Is there any way to do this?
Cheeeeeeèrs!
Basically, I've got a form:

And as you can see, in order to select the right loan (Or even see the loan details, Nursery name, book name, author etc) you have to look in to the loan table and then remember the Loan_ID
GO back into the delete loan table and select the right loan_ID from the combo box...
most people will probably forget before they even get to the delete_loan form :')
So, somehow i'd like to insert some kind of 'sub' table at the bottom of my form..
which will list all the loans from the loan table..
I've tried sub report/sub form.. but it kept updating every time i chose a record in the combobox..(Lets say i selected #5 in my combobox, the table would then only show #5)
I don't want to do anything with it, just show the current loans
Is there any way to do this?
Cheeeeeeèrs!
Last edited: