Is it possible to basically run a For loop through all records?
Say I have two tables:
One that will be populated from a form, and one that will hold some data.
Let’s say Table 1 (T1) is Things
Let’s say Table 2 (T2) is Colors
For all colors in Table 1, submit X for Table 1. For instance:
For Red from T2, describe a Red Thing in T1.
For Orange from T2, describe an Orange Thing in T1.
If there exists an item in T2 that hasn’t been described in T1, make a cell in T1 show incomplete.