Linking to records under conditions

Hi Everyone,

This may be way easier than I realize - but I am running into a bit of a wall on this.

Currently I have an Airtable set up with two tables like this:

Job Requests and Job Options

Basically Job Requests will be jobs requested by clients and be relatively vague by design. I.E. “Graphic of Venus Logo” for each option that I design I create a record under Job options that is then linked with Job Requests, so “Graphic of Venus Logo - A” etc. This also has a “Status” single select field. Basically, once one of the options is selected, I’d like that record to be linked automatically back on the Job Requests table. I am using a Lookup field now, and while it works for giving me a text only answer, I’d prefer it give me a linked record.

Is there a way to do this?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.