Two Step Lookup

Question

I try to use lookup tables to reduce duplication of data entry in linked tables.

Here is a common scenario and I am trying to solve this.

If the lookup value in a table is itself a record, can I do a lookup of that record? So basically, a lookup of a lookup?

It seems that I cannot. But it would be super helpful. Or if anyone has a hacky way to solve this, I’m open to it.

Here is table Data, which has its own lookup field from ‘Activity’ to Table Experiment

Then in table ‘Analysis’ I do a lookup of Experiment from linked record to Data, which AT automatically called Experiment (from Activity)(from Data)

What I want to do now is call a lookup from that Experiment (from Activity)(from Data) lookup field. I don't think AT permits that. Basically, I want to pull in another field/property of Experiment through a lookup. If ‘Experiment’ were a directly linked record, that wouldn’t be a problem. But since that record is itself a lookup, I don’t have that option.

All this chained lookup is to avoid entering the same field info in multiple tables.

Thanks!

achamess · Answer

Answering my own question. I suppose I could have an automation that takes thatExperiment (from Activity)(from Data)field and in a separatefield, directly links to the record fromExperiment. So a duplication that auto-updates. Then from that direct link to Experiment, I could lookup other attributes from Experiment. Not my preferred way. I’d need to hide some of that out of view so that people don’t manually choose records inExperiment.

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded