Trying to do a multiple insert into 2 tables
I'm trying to insert new users into two tables, users and site_members.
I want the newly created users.UserID from the first insert behaviour to be inserted into the site_members.sm_user_id field - but it doesn't appear in the list of available fields.
(The insert single record behaviour creates a session variable for the field, so I can do it for adding records individually).
Any directions much appreciated.