Bob,
Sorry about the rant! It is just so frustrating to see all this great data and not be able to use in the way you and your team intended. I know this is not easy, particularly with the limitations of the current data model and the inability to control the MVP's approach to data management.
The biggest issue is the need to make sure that whatever "key" field is used by the Manufacturer in their pricing docs is also used in the Model field for D-Tools. As you know, for most of the large Manufacturers they use Part# not Model. This is a real dilemma. To make sure pricing is accurate we have resorted to placing the Part# in the Model field (Extron for example). Unfortunately, when we do this we lose access to the D-Tools data. I know no other way to do this.
-ch
|