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?