Originally Posted by
orange
yes I agree totally.
I'm not sure about dropping the sequence number idea, or the fldPrevious, fldNext.
A suggestion, but you may already be beyond this :
I would focus on what I need to do to get a delivery schedule, and then move on to how once I had a technique.
Get some dummy name and address records; concoct something that mimics your real situation, and work out a process as to how to sequence these for delivery. You might even show us some records and your attempts to see if anyone has other ideas(algorithms).
If you don't have some sort of delivery route, or if routes are different every day/week whatever, I'm not sure there is an algorithm. I did see someone from the UK recently on a forum who was trying to optimize routes based on some Google map algorithm, but I don't think anything was optimized -- it just identified spots along the route.
A real life issue where I am, I live at #18, and the house directly across the street from me is #3, (we're the first houses on opposite sides of the street) so there are some "unique" mechanisms for numbering houses in the block.
There are Postal Code and block identifiers available via PostOffice for a price. I guess it depends on how big your operation is and how important optimization is , and at what level of granularity.
I haven't done any optimization, or anything other than trivial, with Google Maps, but I'm sure that line of thinking may offer some approaches (again maybe at a cost).