I have 3 tables: Clients, Contacts, Projects.
I created the following relationship to allow me to do conditional dropdowns based upon which client was selected for a project.
However, I need a Primary and a Secondary contact on most projects and they may change or switch on the next project for the same client. I got it to work for the Primary Contact, but when I try to add the same field again for the secondary contact, it ceases to work. I could use a formula on the Secondary Contact field (possibly), the cascading look-ups for Title, Phone, email, and comments won't display properly. Is there a way of using a duplicate conditional dropdown field?