Loop over form field for multiple insert
another ADDT refugee here, new to WA.
I probably just haven't found it yet, but here's what I need to do:
1. populate multiple tables from a form on insert/update
2. get the record number ID of that just inserted record
3. take that ID and loop over multiple entries in a comma separated "keywords" field and do multiple inserts in a look up table
example for 3: insert> record ID & keyword1, record ID keyword1
recipe, soup, tomato
record | keyword
5 recipe
5 soup
5 tomato
This was pretty easy with Custom Trigger in ADDT, but I'm having trouble doing it in WA DA.