I have three forms in my application: "Projects", "Contacts", and "Activities". On my project form, I associate every new project with a contact. On my activities form, I want to be able to pull up a list of all active projects via a lookup, choose one, and then display that project's contacts details (e.g. full name). How would I go about doing that?

Activities Form Lookup -> Project A -> Project A Contact Record -> Full Name

Thank you!