Conditional Value Lists with tables that have more than one relationship
I understand how to create a conditional value list and have successfully made them. However, I need to create a conditional value list using two tables that already have an existing relationship. When I add the second relationship to represent the conditional value I want to use to filter the list, I end up having no values populate the list, because the relationships are "AND" relationships and both relations are not being met. Thus, nothing populates in the dropdown.
Is there a way to create a conditional value list for this type of relationship?