Populating fields in related table
Thanks in advance for the help. I am trying to make a database for interviewing new candidates. Attached is a screenshot of my database relations. What I'm trying to do is to go to a Pre-Work layout and it prepopulate the candidate name, prework email and manager email from the Candidate table. Please let me know if I need to explain a little better.