Pulling data from another table

Need help
1

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.

image
image1056×288 9.41 KB

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

image
image1892×476 35.3 KB

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.

image
image1528×750 83.9 KB

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

Please help me out ! :slight_smile:
Thanks alot.
Alvin

2

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

3

Hi @Zeroic
Thanks alot.

I did as you mentioned, and it works.

Thank you.
Alvin.

1 Like