My Contacts table has a custom column called Role, the Role values are Role A and Role B
My Intakes table has 2 lookup columns where the full name for associated record as Role A goes and another column for contacts with the full name for the associated record as Role B goes. They will never be the same contact
My intakes main form has both lookup columns When user clicks on FullNameRoleA lookup value I want them to go to a different default contacts form then if they clicked on FullNameRoleB
Is that possible?
thank you