• Hi Drew. Thank you for your response.

    This is my first trigger ever. I have looked at all of the forums on triggers, but I have not been able to find one that does what I want.

    Specifically, when a user has added a new Customer Order record, (which is on the CO table), I want the trigger to automatically add/insert a new

    record onto another table called the OSR table. I need to pass the information from the newly created Customer Order header record and insert that information into

    a new record which does not yet exist on the OSR table.

    I have looked at triggers for insert instead, which almost look like it will do what I want it to do, but am unsure.

    Thanks very much again, for your help.

    Gillian