Some help would be appreciated. 

I have three forms which make up kind of a library for hard drives which come in and out of our office.

The first form (DRIVE_CATALOGUE) establishes a unique ID number for each drive (DRIVEID) and saves some other permanent details. There is also a LOCATION field which is hidden and cannot be edited via the form. It pulls data from the other two forms, depending which was updated most recently (see below.)   

The second form (DRIVE_CHECKOUT) is filled in every time a drive leaves the office, and records where it was sent, at what time/on what date, and who sent it. It pulls the DRIVEID number from DRIVE_CATALOGUE. The SENT_TO field auto-updates the LOCATION field on form DRIVE_CATALOGUE on edit. 

The third form (DRIVE_CHECKIN) is filled out every time a drive comes back into the office and records date/time of check-in plus name of person checking in. Again, i t pulls the DRIVEID number from DRIVE_CATALOGUE. When DRIVE_CHECKIN is filled out, it sets the LOCATION field on the relevant DRIVE_CATALOGUE record to "OFFICE"

Hope that makes sense. So my question is:

I would like to have a report that combines the information from  DRIVE_CHECKOUT and  DRIVE_CHECKIN, so that I have a searchable movement log.. i.e. I would like to be able to search by DRIVEID and pull up a complete history of that particular drive's movements. So that I could see everywhere it had been sent to and every time it had been checked back into the office.

Is this possible? 

Many thanks in advance!