Get value from child to parent while in form

[MarcoComar]

Hello, I need help in figuring this out but I can't seem to get the correct formula. 

I have this parent table (EPE) which has children tables (EPS, DSE, CV) (screenshot 1). On the form of EPE, I want the Employee Performance Survey, Direct Supervisor Endorsement, and Core Values score to be automatically populated based on the score from the actual surveys which will be filled out in the form as well. I.e. EPSscore in the Employee Performance Survey form should automatically populate in the EPE form as well (Screenshot 2)

I tried [Related EPSs][EPSscore] in the App Formula, but it's returning a list. I just want the actual value of that row. 

Please help.

[Suvrutt_Gurjar]

You may want to mention what score should be shown if there are multiple children to EPE table from EPS table. The reason a reverse reference form returns a list is because parent child reference relationship is typically one to many. One parent table record can have multiple children records.

[MarcoComar]

EPE is the parent and EPS is the child. The only thing that I want to get from that sheet is the [EPSscore] of which I'm having a hard time. Using [Related EPSs][EPSscore] is returning a list instead of the actual value. Is there something wrong with my formula? 

[Suvrutt_Gurjar]

May I request you to answer on the following 

---

@Suvrutt_Gurjar wrote:

what score should be shown if there are multiple children to EPE table from EPS table. The reason a reverse reference form returns a list is because parent child reference relationship is typically one to many. One parent table record can have multiple children records.

---

if there is ever going to be just one child record, then you could use an expression of

INDEX([Related EPSs][EPSscore] , 1)

[scott192]

If as @Suvrutt_Gurjar suggested that there is only going to be one child record in your child tables then you can wrap your  [Related EPSs][EPSscore] in an ANY statement to return one value.

ANY([Related EPSs][EPSscore])

[Suvrutt_Gurjar · Accepted solution]

Yes, if there will always be one record then both the below suggestions will work.

---

@Suvrutt_Gurjar wrote:

INDEX([Related EPSs][EPSscore] , 1)

---

or 

---

@scott192 wrote:

ANY([Related EPSs][EPSscore])

---

Edit: Actually, if there will always be just one child record , then you could technically wrap the expression with any of the following functions as well. The list element type needs to be numeric such as number, decimal, price etc.

MIN([Related EPSs][EPSscore])

MAX([Related EPSs][EPSscore])

SUM([Related EPSs][EPSscore])

AVERAGE([Related EPSs][EPSscore])

[MarcoComar]

I appreciate this, thank you so much!

[Suvrutt_Gurjar]

You are welcome.