Viewing data from another form

Viewing data from another form

Hi,

Building a application to allow me to record in a form, the details of conversations with contacts at companies I make contact by telephone.


The user loads a call form (called "Call Record") then selects company_name in a lookup field (linked to a form called "Company). Every company has multiple contacts stored in a form called "Contacts" and linked to the "Company" form. Would like to create an action that, when the user selects company_name in "Call Record" the system loads a form field displaying the contacts unique to the company selected. Any ideas.

Think Zoho is great.

Thanks