Pulling data from another table

domreg · 2024-10-02T11:36:14.538Z

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.

image1056×288 9.41 KB

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

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.

image1528×750 83.9 KB

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

Please help me out !
Thanks alot.
Alvin

Zeroic · 2024-10-02T13:21:05.700Z

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 · 2024-10-03T06:10:53.935Z

Hi @Zeroic
Thanks alot.

I did as you mentioned, and it works.

Thank you.
Alvin.

system · 2024-12-11T11:36:46.860Z

This topic was automatically closed after 70 days. New replies are no longer allowed.