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 is selected from the single-select list.
Is this possible? If so, how??
Thank you in advance!