Can't get fields to auto populate from drop down selection
I have a layout - NewLeads based on the Leads table. The Leads table is linked to the Company table via _CompanyID. I also have a Contacts table linked to the Company table via _CompanyID. I have created a drop down of the Contacts on the _ContactID, limited to the company selected.
My problem is that when I select a contact from the drop down it does not populate the other fields.