AnsweredAssumed Answered

Populate Field from Related Record

Question asked by meleno on Nov 3, 2018
Latest reply on Nov 5, 2018 by meleno

Hello,

 

 

I have a primary table ‘Assets’, which is linked to a secondary table ‘Contacts’.

 

 

 

Within the Assets table, I have two fields:

Full_Name

Full_Name_Email

 

 

 

Within the Contacts table, I have two fields:

Name

Email

 

 

 

Within Assets.Full_Name, I am using the ‘Looked-up Value’ function to select names from Contacts.Name.  Based on this selection, I am looking to populate the Assets.Full_Name_Email with the related record info from Contacts.Email.

 

 

 

So, if Contacts record is:

Name = Bob

Email = Bob@gmail.com

 

 

 

Then

 

 

Within the Assets.Full_Name, user selects “Bob”,

Full_Name_Email is then populated with “Bob@gmail.com

 

Please let me know if anyone can assist.  Thanks

Outcomes