jmcondon8015@yahoo.com

Get record value from related table

Discussion created by jmcondon8015@yahoo.com on Jan 20, 2014
Latest reply on Jan 20, 2014 by erolst

Hello,

 

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.

Outcomes