Pulling data from another table

[domreg]

Hi. I need some help figuring this out.

I have 2 tables.
Table 1 is called milestone with project id in it.
Table 2 is called project with project id and project status in it.

I currently have a repeating group that display information from the milestone table.

What I am trying to achieve is that, I have a dropdown field that will show me status from table project based on the project id in the milestone table.

My current setup doesnt work. I spent hours figuring this out but still failed.

Please help me out !
Thanks alot.
Alvin

[Zeroic]

Hi Alvin, this wouldn’t work because you are referring to the Milestone Status whereas you want to show the Project Status in the dropdown.
Ideally, you can do a search for All Projects, where Milestone contains the Project ID, and then display the unique Status in the dropdown

A better way would be to establish a relationship between your Milestone and Project table, such that a Milestone table contains the field to your Project table. In that case, the expression will be simplified to RepeatingGroup Milestone: each item’s Project: each item’s Project status: unique elements

[domreg]

Hi @Zeroic
Thanks alot.

I did as you mentioned, and it works.

Thank you.
Alvin.