Pipeline to update multiple records?

I am sure this is possible, but not sure of the mechanics.  I need to insert an order number into multiple records in a separate table when a value is entered in a specific field.  For example, suppos...