I have records of deliveries made to customers. Column headings include
depot (a 4 digit id number), customer number, customer name and address.
Each day I manually type in the time taken and distance travelled for each
delivery. These values are preset and do not change. Most of the deliveries
are made from the same depot to the same customer, but occasionally when
product is unavailable the depot of origin will change. I would like a
method of checking customer number and depot of origin and inserting values
in the time and distance columns.
I would appreciate any suggestions.
--
lyn