On a form, how do I change the value of one record picker based on the selection made in another record picker?

Original Post: Asked by kelkington a month ago I have three tables: Contacts, Firms, Comments. All Contact records are linked to a Firm record. Comment records must be linked to the c...