DittoDat lookups - abcsoftware/abc-docs GitHub Wiki

A DittoDat lookup shows what you have entered in this field on other records allowing you to quickly "Ditto the Data" onto this record.

To set up a DittoDat lookup on the Ship Via field on the customer screen:

1. Press Ctrl+G on the Ship Via field.
2. Note that it is Field Number 14 (do not use location).
3. Go to the `X screen.
4. Enter file you are working with (e.g. "C" for "Customer").
5. Enter the field number as a 3-digit number (e.g. "014");
6. In Description enter "ShipVia" (this will show at the top of the lookup).
7. In Filter Type enter ":14".
8. Press F12 to save the lookup configuration.

There is now a lookup on the Ship Via field of the Customer screen. This lookup will show all the Ship Via settings that are currently in your system. To add another item to the list, simply enter it on a customer and it will automatically show up the next time you use the lookup.

Add ":4" to the Filter Type (field 4 is ZIP Code).

Now when you use the lookup on the Ship Via field, you will only see the Ship Via settings that were entered on other customers who have the same ZIP Code as the customer currently on the screen. For example, if the current customer has a ZIP Code of 17067, the lookup will only show the Ship Via settings you have used with other customers in the 17067 ZIP Code. You may add as many fields to the filter as you wish.