Auto-populate based on record
I have two tables - Contacts and Job Management. I am trying to use the contact list and related information to auto-populate other contact related info (email etc) once I "pick" the customer from the drop down list that I created that is targeted to the Contacts table and field of "Cust_Name". What do I need to do to the email field so that it brings the proper one in for that chosen customer? Pics attached and many thanks.