Dynamically populated Drop-Down and List Box Tools

[Mert]

Hi,

I pull two fields from the database to the input tool.

Field 1	Field 2
A	1
A	2
A	3
B	4
B	5
B	6

I would like a drop-down tool to be populated by Field 1, first. Then based on my selection of either A or B, I would like a list box to be populated with relevant values from Field 2.

I tried populating the drop-down menu first with A and B, leveraging Cross-Tab but could not succeed so decided to ask for help. 

Can anyone give me a hand? Thank you in advance.

[Mert]

I know it's a bit unusual to answer my own question, but I figured it out right after my first message. Posting here gave me the push I needed.

To help others with a similar need, I’m sharing a screenshot below.