I am not using email but I am using SQL Server in a similar way. I have found some inconsistencies depending on the type of data source I am using. ODC seems to be least problematic.
I just worked through a field lookup problem. I traced the form and found that the database was returning results but I was not getting them in the form. This was ...