Recent content by mike_g

Hmm... I was kind of hoping this question would have a simple one line answer, but maybe its not that easy. I am not sure if this helps but here are my tables (if thats what you meant by DB structure): There is also a field in copies called 'Current Loan' that I forgot to drag out. When the...

Hi! I'm making a test database for DVD rentals. When A loan is made I have an update query that sets some fields in the DVD copy table. One of these fields needs to be set to the primary key of the loan made. This would be the last entry on the loans table. I don't have any idea what to put in...