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 the 'Update To' box in the query though.
Wrong code here, but this may help explain what I am trying to get:
Also heres an image of my query:
Help would be much appreciated. Thanks