I've a form that uses a combo box to find a record by the primary key (ID number), and then to load all associated records (clinic appointments). I'd like however to use a combo box to search for a record in the table not by the primary key, but by the patient surname, and then by using the...