I can't seem to find the answer to this very simple request.
I have two forms Company and Contacts. There is a lookup field in the Contacts form that has you select a company from the company form.
I want to create a 3rd form that will have a company lookup field and a Contacts lookup field. I want the contact lookup field to only list the contacts that are have the same value as the Company lookup field on the same form. Currently it only shows all the contacts for all of the companies.