I have a primary table ‘Assets’, which is linked to a secondary table ‘Contacts’.
Within the Assets table, I have two fields:
Within the Contacts table, I have two fields:
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
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