Really large value list unreliable

[Hijack]

Hey all,

Anyone know of a reliable way of making a very large value list resolve correctly? Example: I have a table of data from an Internet source of network adapter first six MAC characters to vendor. Really simple. Two fields. First six of the MAC and the vendor assigned to that prefix. Ex: 005056 = "VMWare, Inc.". The table has 5630 entries.

I have a field in a database to hold the full MAC of a device and a companion calc field to take the first 6 digits after stripping out any colons ( or hyphens (-). I have a double field value list of all the values from the Internet source table (first field is MAC first six, second field is the Vendor string). If I overlay that value list over the calc field it will resolve the vendor name of the digits up to a point but if the MAC value is too far into the value list, I just get the displays the MAC value.

I've clearly surpassed the limit of a workable value list.

Anyone have a suggestion on how to correctly display the vendor info in this situation?

Thanks

[bcooney]

"If I overlay that value list over the calc field it will resolve the vendor name of the digits up to a point but if the MAC value is too far into the value list, I just get the displays the MAC value."

That's where you lost me. Can you post a sample file?

Why is this a value list and not a lookup or a relationship from first 6 char to first 6 char? And where is the VendorID in all this? Isn't that the goal?