Get record value from related table

Discussion created by on Jan 20, 2014
Latest reply on Jan 20, 2014 by erolst



I created a Parent Table of employees with a unique id (userid). Next I created a child table of devices linked by username with a unique id of serial number.


On the Parent table, I wanted to create a calculated field that:

1) looks at the device table,

2) checks to see if the username has a device type of "cellphone"

3) returns the phone number value from the device table to the cell phone field on the employee table


I used a caluclated field that returns the cell phone number if the type matches. The problem I run into is if the cell phone is not the last device in the device table, it returns the false response.


If(Devices::Equipment Type="Smartphone";Devices::Phone Number)


Any advice would be appreciated.