Depending on how data is organized, customized separation of single row data into Customer & Project tables
may be systematic based on consistent data or by exception hard coded for expediency.
Custom rules for you.
Over years with many customers and many projects, the color tables may be littered
with identical color/Labs.
We designed procedures to auto-identify, by exception manually stage, and finally batch process consolidation.
Prudently cautious, the procedures to separate Customer-Projects, to consolidate colors,
and apply new color descriptions build an entirely separate database
that can be sampled, viewed and used in the database selection.
• Based in the Chicago metro area
• Local & Remote Implementations