Update via MySQL

[papeter]

Hi all,
I am trying to import a large number of companies into the accounts table with MySql. This all worked fine, and in the frontend I can see my data coming back, all records/ companies loaded perfectly except the field Industry.

So I changed all the items in the Industry dropdown to whatever files are in my source table (15 different items) and created an update query. Unfortenately the field still won't accept any data.

Does anybody know how to fix this?

Thanks,
Peter

[sacramentojoe]

Well, if you ask me, sounds like your industry Drop down is a custom field, which means you should be updating the custom table right?

You need to make sure that your Keys in the dropdown match the values being saved in the DB on the backend.

[papeter]

Thanks, it worked.