List Only Contacts relative to Customer
We have two forms, say Form A and Form B. In form A we collect basic info Account Name Contact Title Email. We also have 6 other fields for Contact2 Title2 Email2 and Contact3 Title3 Email3. Over in Form B the first field is Customer (same as Account Name in form A). What I hope to accomplish in a lookup field is once we select the Customer that in the next lookup field only the Contacts (Contact, Contact2,Contact3 ) relative to the Account Name will show and then once we select a contact their email will populate. I think I may have the code for the email part figured out but not the rest. Thanks for any and all help provided. Cheers!