We've created a lookup helper class that's going to be part of Data Sync 3.0 to help when you need to lookup values that are in a different SQL Table in Dynamic Columns. You need to import the Simego.DataSync library and then create an Instance of the OleDbDataLookupHelper object. This is a generic object so you can define the Key and Value type as any base type. Then you need to populate the list with values in the Setup method. Finally return a value by calling Lookup.Items[key]. The example below shows all the parts and as you can see it's just a few lines of code.