Dynamic dropdown element does not show data in repeating group

Need help Database
1

What do I intend to do?

I want to show a dropdown in which I want to show a list of industries (Marketing, Doctors, Finance). Each of these industries will have a list of job titles (Eg. Marketing > marketing manager, SEO Manager, and Finance > Accountant, Account associate).

No, I want my app used to be able to choose the industry from the dropdown, the basis of which only the related job titles show up in a repeating group.

Not sure how to set this up in option sets - we are looking at 26 industries and 300+ titles.

This is what I did I created 2 databases (Industries & Titles) refer screenshot

image
image2610×792 245 KB

image
image2692×782 214 KB

And then correctly set the dropdown and repeating group - The problem is except for the Marketing group titles don’t show up if I choose a different industry in the dropdown.

Refer this screenshots

image
image1004×730 18 KB

image
image1028×496 3.61 KB

image
image1588×1072 96.4 KB

image
image1930×976 118 KB

image
image1898×906 75.4 KB

Am I missing something? Or is there a better way to do this?

2

Your Search for Titles should say Job Titles is in (not contains) Dropdown Choose Industry’s value’s Title (not Industry Name). Or you could do an advanced filter and say Dropdown Choose Industry’s value’s Title contains This Titles Job Titles.