New to AirTable, we’re using it to run some data asset surveys.
We are looking at a way to cross reference two tables like so:
We have following tables:
- Data Assets
- Data Elements
- Data Processes
- Data Asset Survey
- Data Processes Survey
- Data Asset Survey links multiple Data Elements per Data Assets.
- Data Processes Survey links Data Elements and Data Assets (source of data element) independently.
We want to be able to check that Data Elements linked under a Data Process Survey record indeed exist for the Data Assets declared in the same record. This could be done:
- either by filtering input choices of Data Elements based on declared Data Asset, or vice versa,
- or by adding some extra column that will verify that the Data Element - Data Asset relationship indeed exists.
Not sure if this is explained clearly.
In other terms, if we associate A and B to record C, we need to check whether the A-B relationship already exists, to either limit input or to throw a warning after input.
What do we need to do to achieve that?