Table relation problems in SQL

We just recently upgraded from the 2.6 client to 3.7, and afterwards we have this strange problem. On the Sales Comment Line.Code field, we have a relation to an external table called Memo Type that stores the Codes that a user is allowed to enter in that field. This Memo Type table also has seperate fields on it to tell the system whether the Code can be used on a Sales Order, Customer, or another custom table of ours. Before we upgraded to the 3.7 client only, this worked with users able to just enter the letter of the code, hit tab, and enter their data. After the upgrade, this still works fine on my local database (C/SIDE), but now on the production SQL side, it pops up and error “There is no Memo Type within the filter. Filters: Code: A, Sales Order: Yes”. We have two records in the Memo Type table that start with the letter A, but only one within the Sales Order filter, which is called All. Other records that do not have the same the letter as another code still work fine. Any suggestions? My users are driving me crazy with this one, since we use it a lot.

Go into your Memo Type table and enter one for those values, and you should be fine.

I thing you are missing the setup data. As Daniel Said, insert the data in the Memo Type Setup tabel, and you will be fine. Naveen Jain