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.