Inherit data from selected record into a new record

[DLM]

Hi all

I hope I can explain my question clearly enough. 

I have three tables - Job List, Candidate List, Applications

From Job List, I want to select a job and create a new Application record which will inherit the selected job title into the job title field on the Application record. This would also be a parent-child relationship.

Can anyone tell me if this is possible to do?

[Zack_S]

Hi @DLM - Yes this is possible.

In the Applications table create a lookup field from the Job List and select the job title.

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

[DLM]

Hi Zack, thank you very much for your response! I do know I can do it that way but it adds extra steps that I was hoping to avoid so my question is if data 'inheritance' from a selected record in a linked table is possible in Airtable, either from the data table or interface?  I used to develop applications in Lotus Notes which had this inheritance functionality built in. 

Attachment:
Red comments are the steps to create the application record.
Black arrow is item that is 'inherited' from job record to application record.

[DLM · Accepted solution]

I ended up using automation to imitate the 'inherit' functionality.