I have a delivery service which is composed of various routes.  The
route stops have been defined in database tables.  Route sheets are
printed based upon these tables.  However, I need to have the stops
print in an particular order/sequence; i.e. first stop, second stop,
etc. although these records are not in sequence order in their
table(s).  My problem is that I must manually assign a sequence number
to each stop and there may be a hundred or more stops on a route which
changes as stops are added or deleted which would effect the
sequencing.  How can I automate assigning a sequence number for
printing to each stop and have it automatically re-number the
sequencing as stops are added or deleted?  Will I need to write a
query sort?  Any suggestions will be appreciated.  Thank you!