Script to search another database for a term
I have two databases to manage submissions to an academic journal that I want to "connect." The first database has information about the article submitted ("Works" database). The second database has contact details about the scholar (basic "Contacts" template database). Both databases have entries for "Last Name."
I want a button, associated with the "Last Name" field of the Works database, that will search for matching entries in the "Last Name" field of the Contacts database.
Any idea on how to go about this? Or any suggestions on better ways to connect the two databases?