On Wed, Feb 8, 2012 at 1:26 PM, Jeff Roberts <[email protected]> wrote: ... > From what I can see when you ask for shipto addresses it queries the shipto > table for all unique addresses that are associated with that customer from > the entire history. The trouble may be in determining what the criteria for > "unused" is. If you do it by date you could end up re-typing addresses just > because you haven't shipped to that location in a year, etc. You could then > add a date selection process somewhere to determine how far back to look for > addresses eg: 6 months, 1 year, all... but that adds extra clicks to the > process that may not be desirable for others.
Why not have the system simply select the next N most recently used shipto addresses for that customer, where N is a configurable parameter with a reasonable default? -- Best Regards, Wallace _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
