I have a series of 13 custom lists where each of them has a common
ID field. My client is using these lists and a make-shift work flow
which begins when a user enters an item in the first list. I want to
add a record to each of the other 12 lists using the ID populated from
the first list.
I was thinking of using an AFTER INSERT SQL
Trigger on the UserData table but have been advised to stay away from
directly accessing the SQL tables directly. What other options are
available to me?