0 Replies Latest reply on Jun 20, 2008 11:40 PM by (rmeasy)

    Bring information from another table using Custom Trigger

      I have 2 tables, one for *users* and another for *access* to site.
      On users table I have a field user_kind (kind of user) that means which level for users login.
      On access table there are fields for email, password and level.

      I have created a page with "insert into two tables wizard" and it works fine.
      But now I need to put the user_kind's value from the users table into the level's field from the access table.

      Should I have to use a Custom Trigger in After mode?

      How can I do this?

      Thanks.