Superkalle,
I've been using your app for a while and is very useful to keep inventories.
One thing that I like to use a lot is the Batch replace utility. First I go to the model's color substitution analysis to ensure a whole color can be replaced. Then go to the color summary and copy the table of parts for that color. I paste the table in excel and add another column repeating the part number, then a column with the original color number and finally a column with the replacement color number. Now I go to the batch replace and paste the table from excel.
The problem is that the batch replace only accepts DesignIDs, not BLitemIDs, so some parts are not accepted (since their IDs don't match), and although access allows to paste the rest of the records, the file generated contain several parts that were not changed.
I'm wondering if you can either add a column with the DesignIDs in the Color summary table or modify the batch replace to accept BLitemIDs instead. I have the impression that one nomenclature is more reliable than the other so you may know which is the best choice.
Thank you again for your wonderful program!