Mirror a user name from one table to another

[Rahmanberrada]

Hi everyone, 

New to Airtable but love it so far, and am hoping to have the following question answered. 

I am creating a project / task tracker for my team, ultimately going to create an interface which would have the following hierarchy:

Project > Tasks > Subtasks. 

I know I only have 3 levels so I'm trying to display the DRI name under the Subtask table in order for me to group it correctly. 

I created the correct tables which are linked properly (I think). 

Here is my question: How can I mirror the DRI in my Project table to auto-populate in my task and subtask tables? This will help me group my views properly. 

Thank you

[TheTimeSavingCo · Accepted solution]

Hm, may I know what difficulties you faced using a lookup field?  Seems like it'd do the job

https://support.airtable.com/docs/lookup-field-overview

[Rahmanberrada]

That did it - Not sure why it wasn't working before, but I had to recreate the tables and connect them again, this time it worked fine. 

Thank you 

Rahman