There are two methods for designing custom workflows for
SharePoint.
1) Microsoft Office Sharepoint Designer 2007 provides a fairly
straightforward way of designing workflows using a pick-and-choose
strategy from a pre-defined list of possible workflow actions.
Additional actions are available from 3rd party sites.
2) Visual Studio can be used to create complex custom
workflows