I have a table where each record is a referral.
One of the fields in this table is a single-select field called Status. One of the options to select is “INTAKE.”
What I want is for the record to populate a second table, called Intakes, only if INTAKE...